ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 41D6D842E8D2CF9DE06362FB0905A273 SELECT mms.parent_movement_id C_PARENT_MOVEMENT_ID, mms.invoice_id C_INVOICE_ID, mms.movement_id C_MOVEMENT_ID, mms.transaction_nature C_TRANSACTION_NATURE, mms.delivery_terms C_DELIVERY_TERMS, /* ER-35896486:Germany Requirements Start */ /* mms.dispatch_territory_eu_code || '-' || mms.dispatch_territory_code C_DISPATCH_TERR_EU_CODE, mms.destination_territory_eu_code || '-' || mms.destination_territory_code C_DESTINATION_TERR_EU_CODE, mms.origin_territory_eu_code || '-' || mms.origin_territory_code C_ORIGIN_TERR_EU_CODE, */ CASE WHEN (mms.movement_type IN ('A','DA') and mms.destination_territory_code = 'DE') OR (mms.movement_type IN ('D','AA') and mms.dispatch_territory_code = 'DE') THEN mms.dispatch_territory_code ELSE mms.dispatch_territory_eu_code || '-' || mms.dispatch_territory_code END C_DISPATCH_TERR_EU_CODE, CASE WHEN (mms.movement_type IN ('A','DA') and mms.destination_territory_code = 'DE') OR (mms.movement_type IN ('D','AA') and mms.dispatch_territory_code = 'DE') THEN mms.destination_territory_code ELSE mms.destination_territory_eu_code || '-' || mms.destination_territory_code END C_DESTINATION_TERR_EU_CODE, CASE WHEN (mms.movement_type IN ('A','DA') and mms.destination_territory_code = 'DE') OR (mms.movement_type IN ('D','AA') and mms.dispatch_territory_code = 'DE') THEN mms.origin_territory_code ELSE mms.origin_territory_eu_code || '-' || mms.origin_territory_code END C_ORIGIN_TERR_EU_CODE, /* ER-35896486:Germany Requirements End */ mms.area C_AREA, mms.port C_PORT, mms.stat_type C_STAT_TYPE, mms.inventory_item_id C_INVENTORY_ITEM_ID, mms.document_source_type C_DOCUMENT_SOURCE_TYPE, round( (mms.item_cost * :P_EXCHANGE_RATE), :cp_ext_precision_func ) C_ITEM_COST, mms.item_description C_ITEM_DESCRIPTION, mms.document_reference C_DOCUMENT_REFERENCE, mms.document_line_reference C_DOCUMENT_LINE_REFERENCE, mms.invoice_batch_reference C_INVOICE_BATCH_REFERENCE, mms.invoice_reference C_INVOICE_REFERENCE, mms.invoice_line_reference C_INVOICE_LINE_REFERENCE, mms.transaction_date C_TRANSACTION_DATE, mms.transaction_uom_code C_TRANSACTION_UOM_CODE, round( (mms.currency_conversion_rate * :P_EXCHANGE_RATE), 5 ) C_CURRENCY_CONVERSION_RATE, mms.currency_code C_MOVEMENT_CURRENCY_CODE, mms.outside_code C_OUTSIDE_CODE, mms.customer_vat_number C_VAT_NUM, mms.report_reference C_REPORT_REFERENCE, mms.transport_mode C_TRANSPORT_MODE, mms.customer_name C_CUSTOMER_NAME, mms.transacting_from_org C_TRANSACTING_FROM_ORG, mms.transacting_to_org C_TRANSACTING_TO_ORG, mms.vendor_name C_VENDOR_NAME, mms.ship_to_customer_id C_SHIP_TO_CUSTOMER_ID, mms.ship_to_site_use_id C_SHIP_TO_SITE_USE_ID, mms.vendor_id C_VENDOR_ID, mms.vendor_site_id C_VENDOR_SITE_ID, mms.from_organization_id C_FROM_ORGANIZATION_ID, mms.to_organization_id C_TO_ORGANIZATION_ID, mms.customer_number C_CUSTOMER_NUMBER, mms.vendor_number C_VENDOR_NUMBER, mms.customer_location C_CUSTOMER_LOCATION, mms.vendor_site C_VENDOR_SITE, mms.po_header_id C_PO_HEADER_ID, mms.order_header_id C_ORDER_HEADER_ID, mms.po_line_id C_PO_LINE_ID, mms.order_line_id C_ORDER_LINE_ID, mms.invoice_batch_id C_INVOICE_BATCH_ID, mms.alternate_uom_code C_ALTERNATE_UOM_CODE, mms.movement_status C_MOVEMENT_STATUS, mms.shipment_reference C_SHIPMENT_REFERENCE, mms.po_line_location_id C_PO_LINE_LOCATION_ID, mms.shipment_line_reference C_SHIPMENT_LINE_REFERENCE, mms.shipment_line_id C_SHIPMENT_LINE_ID, mms.receipt_reference C_RECEIPT_REFERENCE, mms.pick_slip_reference C_PICK_SLIP_REFERENCE, mms.picking_line_id C_PICKING_LINE_ID, mms.invoice_date_reference C_INVOICE_DATE_REFERENCE, mms.shipment_header_id C_SHIPMENT_HEADER_ID, mms.comments C_COMMENTS, mms.container_type_code C_CONTAINER, mms.statistical_procedure_code C_STATISTICAL_PROCEDURE, mms.customer_trx_line_id C_CUSTOMER_TRX_LINE_ID, mms.movement_type C_MOVEMENT_TYPE, mms.requisition_header_id C_REQUISITION_HEADER_ID, mms.requisition_line_id C_REQUISITION_LINE_ID, mms.mtl_transaction_id C_MTL_TRANSACTION_ID, mms.distribution_line_number C_DISTRIBUTION_LINE_NUMBER, mms.rcv_transaction_id C_RCV_TRANSACTION_ID, mms.commodity_code C_COMMODITY_CODE, mms.commodity_description C_COMMODITY_DESCRIPTION, msi.primary_uom_code C_PRIMARY_UOM_CODE, mstl.description C_ITEM_DESC, fl.meaning C_MEANING, INV_INVSTMVT_XMLP_PKG.cf_release_numberformula(mms.rcv_transaction_id) CF_RELEASE_NUMBER, INV_INVSTMVT_XMLP_PKG.cf_parent_mvt_terr_codeformula( mms.dispatch_territory_eu_code || '-' || mms.dispatch_territory_code, mms.destination_territory_eu_code || '-' || mms.destination_territory_code ) CF_PARENT_MVT_TERR_CODE, INV_INVSTMVT_XMLP_PKG.cf_commodity_fieldformula() CF_COMMODITY_FIELD, INV_INVSTMVT_XMLP_PKG.cf_parent_mvt_quantityformula( sum(alternate_quantity) over (partition by parent_movement_id), sum(transaction_quantity) over (partition by parent_movement_id) ) CF_PARENT_MVT_QUANTITY, INV_INVSTMVT_XMLP_PKG.cf_precision_trxformula(mms.currency_code) CF_PRECISION_TRX, INV_INVSTMVT_XMLP_PKG.cf_parent_mvt_uomformula(mms.alternate_uom_code, mms.transaction_uom_code) CF_PARENT_MVT_UOM, INV_INVSTMVT_XMLP_PKG.cf_statistical_value_rformul( ( sum(stat_ext_value) over (partition by parent_movement_id) ) * :P_EXCHANGE_RATE ) CF_STATISTICAL_VALUE_R, INV_INVSTMVT_XMLP_PKG.cf_transaction_value_rformul( ( sum(movement_amount) over (partition by parent_movement_id) ) * :P_EXCHANGE_RATE ) CF_TRANSACTION_VALUE_R, INV_INVSTMVT_XMLP_PKG.cf_invoiceformula( mms.document_source_type, mms.invoice_reference, mms.invoice_id, mms.movement_type ) CF_INVOICE, INV_INVSTMVT_XMLP_PKG.cf_invoice_batchformula( mms.document_source_type, mms.invoice_batch_reference, mms.invoice_batch_id ) CF_INVOICE_BATCH, INV_INVSTMVT_XMLP_PKG.cf_invoice_lineformula( mms.document_source_type, mms.invoice_line_reference, mms.movement_type, mms.distribution_line_number, mms.customer_trx_line_id ) CF_INVOICE_LINE, INV_INVSTMVT_XMLP_PKG.cf_invoice_uom_codeformula( mms.customer_trx_line_id, mms.transaction_uom_code ) CF_INVOICE_UOM_CODE, fnd_flex_xml_publisher_apis.process_kff_combination_1( 'CF_ITEM_FIELD', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE' ) CF_ITEM_FIELD, INV_INVSTMVT_XMLP_PKG.cf_shipment_lineformula( mms.document_source_type, mms.shipment_line_reference, mms.shipment_line_id ) CF_SHIPMENT_LINE, INV_INVSTMVT_XMLP_PKG.cf_receipt_numberformula( mms.document_source_type, mms.receipt_reference, mms.pick_slip_reference, mms.shipment_header_id, mms.shipment_reference ) CF_RECEIPT_NUMBER, INV_INVSTMVT_XMLP_PKG.cf_shipment_numberformula( mms.document_source_type, mms.shipment_reference, mms.po_line_location_id ) CF_SHIPMENT_NUMBER, INV_INVSTMVT_XMLP_PKG.cf_source_line_numberformula( mms.document_source_type, mms.document_line_reference, mms.po_line_id, mms.order_line_id, mms.movement_type, mms.requisition_line_id ) CF_SOURCE_LINE_NUMBER, INV_INVSTMVT_XMLP_PKG.cf_source_numberformula( mms.document_source_type, mms.document_reference, mms.po_header_id, mms.order_header_id, mms.movement_type, mms.requisition_header_id, mms.mtl_transaction_id ) CF_SOURCE_NUMBER, INV_INVSTMVT_XMLP_PKG.cf_trader_numberformula( mms.document_source_type, mms.customer_number, mms.ship_to_customer_id, mms.vendor_number, mms.transacting_from_org, mms.transacting_to_org ) CF_TRADER_NUMBER, INV_INVSTMVT_XMLP_PKG.cf_trader_siteformula( mms.document_source_type, mms.customer_location, mms.ship_to_site_use_id, mms.vendor_site, mms.customer_name, mms.vendor_name, mms.transacting_from_org, mms.transacting_to_org ) CF_TRADER_SITE, INV_INVSTMVT_XMLP_PKG.cf_trader_typeformula( mms.document_source_type, mms.customer_name, mms.vendor_name, mms.transacting_from_org, mms.transacting_to_org ) CF_TRADER_TYPE, INV_INVSTMVT_XMLP_PKG.cf_trader_nameformula( mms.document_source_type, mms.customer_name, mms.ship_to_customer_id, mms.vendor_name, mms.from_organization_id, mms.to_organization_id, mms.transacting_from_org, mms.transacting_to_org ) CF_TRADER_NAME, INV_INVSTMVT_XMLP_PKG.cf_outside_value_rformula( sum(outside_ext_value) over (partition by parent_movement_id), INV_INVSTMVT_XMLP_PKG.cf_precision_trxformula(mms.currency_code) ) CF_OUTSIDE_VALUE_R, INV_INVSTMVT_XMLP_PKG.cf_document_line_ext_val_rform( sum(document_line_ext_value) over (partition by parent_movement_id), INV_INVSTMVT_XMLP_PKG.cf_precision_trxformula(mms.currency_code) ) CF_DOCUMENT_LINE_EXT_VAL_R, INV_INVSTMVT_XMLP_PKG.cf_invoice_line_ext_val_rformu( sum(invoice_line_ext_value) over (partition by parent_movement_id), INV_INVSTMVT_XMLP_PKG.cf_precision_trxformula(mms.currency_code) ) CF_INVOICE_LINE_EXT_VAL_R, (msi.concatenated_segments) C_ITEM_FLEX, sum(transaction_quantity) over(partition by mms.parent_movement_id) C_TRANSACTION_QUANTITY, sum(alternate_quantity) over(partition by mms.parent_movement_id) C_ALTERNATE_QUANTITY, sum(primary_quantity) over(partition by mms.parent_movement_id) C_PRIMARY_QUANTITY, sum(invoice_quantity) over(partition by mms.parent_movement_id) C_INVOICE_QUANTITY, /* ER-35896486:Germany Requirements Start */ /* sum(total_weight) over(partition by mms.parent_movement_id) C_TOTAL_WEIGHT, */ CASE WHEN (mms.movement_type IN ('A','DA') and mms.destination_territory_code = 'DE') OR (mms.movement_type IN ('D','AA') and mms.dispatch_territory_code = 'DE') THEN INV_MGD_MVT_UTILS_PKG.Round_Number(sum(total_weight) over(partition by mms.parent_movement_id), 0,'NORMAL') ELSE INV_INVSTMVT_XMLP_PKG.cf_transaction_value_rformul(sum(total_weight) over(partition by mms.parent_movement_id)) END C_TOTAL_WEIGHT, /* ER-35896486:Germany Requirements End */ sum(invoice_line_ext_value) over(partition by mms.parent_movement_id) C_INVOICE_LINE_EXT_VALUE, sum(document_line_ext_value) over(partition by mms.parent_movement_id) C_DOCUMENT_LINE_EXT_VALUE, /* ER-35896486:Germany Requirements Start */ /* sum(outside_ext_value) over(partition by mms.parent_movement_id) C_OUTSIDE_EXT_VALUE, ( sum(movement_amount) over(partition by mms.parent_movement_id) ) * :P_EXCHANGE_RATE C_TRANSACTION_VALUE, ( sum(stat_ext_value) over(partition by mms.parent_movement_id) ) * :P_EXCHANGE_RATE C_STATISTICAL_VALUE */ CASE WHEN (mms.movement_type IN ('A','DA') and mms.destination_territory_code = 'DE') OR (mms.movement_type IN ('D','AA') and mms.dispatch_territory_code = 'DE') THEN CASE WHEN ((sum(movement_amount) over (partition by mms.parent_movement_id)) * :P_EXCHANGE_RATE) between 0 and 0.5 THEN 1 ELSE INV_MGD_MVT_UTILS_PKG.Round_Number((sum(movement_amount) over (partition by mms.parent_movement_id)) * :P_EXCHANGE_RATE, 0,'NORMAL') END ELSE INV_INVSTMVT_XMLP_PKG.cf_transaction_value_rformul( ( sum(movement_amount) over (partition by mms.parent_movement_id) ) * :P_EXCHANGE_RATE ) END C_TRANSACTION_VALUE, CASE WHEN (mms.movement_type IN ('A','DA') and mms.destination_territory_code = 'DE') OR (mms.movement_type IN ('D','AA') and mms.dispatch_territory_code = 'DE') THEN CASE WHEN ((sum(stat_ext_value) over (partition by mms.parent_movement_id)) * :P_EXCHANGE_RATE) between 0 and 0.5 THEN 1 ELSE INV_MGD_MVT_UTILS_PKG.Round_Number((sum(stat_ext_value) over (partition by mms.parent_movement_id)) * :P_EXCHANGE_RATE, 0,'NORMAL') END ELSE INV_INVSTMVT_XMLP_PKG.cf_statistical_value_rformul( ( sum(stat_ext_value) over (partition by mms.parent_movement_id) ) * :P_EXCHANGE_RATE ) END C_STATISTICAL_VALUE /* ER-35896486:Germany Requirements End */ FROM mtl_movement_statistics mms, mtl_system_items_kfv msi, fnd_lookups fl, mtl_system_items_tl mstl --Bugfix 18839247 WHERE mms.inventory_item_id = msi.inventory_item_id(+) and mms.organization_id = msi.organization_id(+) and msi.inventory_item_id = mstl.inventory_item_id and msi.organization_id = mstl.organization_id and mstl.language = USERENV('LANG') and fl.lookup_type = 'MVT_SOURCE_DOCUMENT_TYPES' and fl.lookup_code = mms.document_source_type and mms.movement_type = :P_MOVEMENT_TYPE and mms.entity_org_id = :P_LEGAL_ENTITY_ID and mms.zone_code = :P_ZONE_CODE and upper(mms.usage_type) = upper(:P_USAGE_TYPE) and upper(mms.stat_type) = upper(:P_STAT_TYPE) and mms.period_name = :P_PERIOD_NAME and ( mms.movement_status = 'O' or mms.movement_status = 'V' ) &LP_MVT_ID_WHERE ORDER BY C_COMMODITY_CODE, C_PARENT_MOVEMENT_ID, C_MOVEMENT_ID, C_TRANSPORT_MODE, C_TRANSACTION_NATURE, C_DISPATCH_TERR_EU_CODE, C_DESTINATION_TERR_EU_CODE Y INV INVSTMVT_XML AR INV تقرير إحصائيات النقل (بتنسيق XML) (1) Imported from BI Publisher Description: تقرير إحصائيات النقل ( تقريرINTRASTAT ) Application: المخازن Source: تقرير إحصائيات النقل (بتنسيق XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG D INV Bewegungsstatistiken (1) Imported from BI Publisher Description: Auswertung "Bewegungsstatistiken" (INTRASTAT-Auswertung) Application: Lager Source: Bewegungsstatistiken (XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG E INV Estadísticas de Movimiento (1) Imported from BI Publisher Description: Informe Estadísticas de Movimiento (Informe INTRASTAT) Application: Inventory Source: Estadísticas de Movimiento (XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG F INV Déclaration d'échanges de biens (1) Imported from BI Publisher Description: Déclaration d'échanges de biens (état INTRACOMMUNAUTAIRE) Application: Inventory Source: Déclaration d'échanges de biens (XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG I INV Rapporto Statistiche movimenti (1) Imported from BI Publisher Description: Rapporto Statistiche movimenti (Rapporto INTRASTAT) Application: Inventory Source: Rapporto Statistiche movimenti (XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG JA INV 移動統計レポート (1) Imported from BI Publisher Description: 移動統計レポート (INTRASTATレポート) Application: Inventory Source: 移動統計レポート(XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG KO INV 이동 통계 보고서 (1) Imported from BI Publisher Description: 이동 통계 보고서(INTRASTAT 보고서) Application: Inventory Source: 이동 통계 보고서(XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG PTB INV Relatório de Estatísticas de Movimentação (1) Imported from BI Publisher Description: Relatório de Estatísticas de Movimentação (Relatório INTRASTAT) Application: Inventário Source: Relatório de Estatísticas de Movimentação (XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG RU INV Отчет о статистике перемещения (1) Imported from BI Publisher Description: Отчет о статистике перемещения (отчет INTRASTAT) Application: Запасы Source: Отчет о статистике перемещения (XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG S INV Varuleveransstatistik - rapport (1) Imported from BI Publisher Description: Varuleveransstatistikrapport (INTRASTAT-rapport) Application: Inventory Source: Varuleveransstatistik - rapport (XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG TR INV Hareket İstatistikleri Raporu (1) Imported from BI Publisher Description: Hareket İstatistikleri Raporu (INTRASTAT Raporu) Application: Stok Yönetimi Source: Hareket İstatistikleri Raporu (XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG US INV Movement Statistics (1) Imported from BI Publisher Description: Movement Statistics Report (INTRASTAT Report) Application: Inventory Source: Movement Statistics Report (XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG ZHS INV 移动统计数据报表 (1) Imported from BI Publisher Description: 移动统计报表（INTRASTAT 报表） Application: 库存管理系统 Source: 移动统计数据报表 (XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG BI Publisher 1=1 :cp_application :cp_contact_person_name :cp_end_date :cp_entity_address_line_1 :cp_entity_address_line_2 :cp_entity_address_line_3 :cp_ext_precision_func :cp_legal_entity_name :cp_mv_type_cov :cp_precision_func :cp_rep_option_cov :cp_report_title :cp_request_time :cp_requested_by :cp_responsibility :cp_set_of_books_name :cp_standard_uom :cp_start_date :cp_stat_type_cov :cp_sysdate :cp_tax_office_address_line_1 :cp_tax_office_address_line_2 :cp_tax_office_address_line_3 :cp_tax_office_name :cp_telephone_number_1 :cp_telephone_number_2 :cp_usage_type_cov :cp_vat_registration_number :cp_zone_name_cov :p_amount_display :p_conc_request_id :p_currency_code :p_exchange_rate :p_exchange_rate_char :p_legal_entity_id :p_movement_type :p_mvt_id_where :p_oe_or_om :p_period_name :p_quantity_precision :p_rep_precision :p_rep_rounding :p_report_option :p_stat_type :p_usage_type :p_user_id :p_zone_code :plex_commodity_flex :plex_commodity_order_by :plex_commodity_struct_num :plex_item_flex :plex_item_struct_num :qty_precision 1 -40 :p_dummy Char Select 'Y' from dual where :$flex$.report_option IN ('O/S','S/S') US INV_SRS_CHARACTER Control enable/disable - hidden 2 -30 :p_inverse_rate Char fnd_profile.value('DISPLAY_INVERSE_RATE') Y US CST_SRS_INVERSE_RATE Inverse rate - hidden field 3 -20 :p_rate_type Number fnd_profile.value('CST_EXCHANGE_RATE_TYPE') Y US CST_SRS_RATE_TYPE Rate type - hidden field 4 -10 :debugflag Char N US DebugFlag Debug Flag 5 10 :p_legal_entity_id LOV Oracle INV_MGD_MVT_LEGAL_ENTITY Y select legal_entity_id id, name value, null description from xle_firstparty_information_v where sysdate between nvl(le_effective_from,sysdate) and nvl(le_effective_to,sysdate) and exists (select null from mtl_stat_type_usages where legal_entity_id=xle_firstparty_information_v.legal_entity_id) and exists (select null from xle_fp_ou_ledger_v where mo_global.check_access(operating_unit_id)='Y' and legal_entity_id=xle_firstparty_information_v.legal_entity_id) order by name SELECT name, legal_entity_id FROM xle_firstparty_information_v WHERE sysdate between NVL(le_effective_from, sysdate) and nvl(le_effective_to, sysdate) AND EXISTS (SELECT NULL FROM mtl_stat_type_usages WHERE legal_entity_id = xle_firstparty_information_v.legal_entity_id) AND legal_entity_id = XLE_UTILITIES_GRP.Get_Defaultlegalcontext_Ou(MO_UTILS.Get_Default_Org_ID) Y US Legal Entity Legal Entity id 6 20 :p_zone_code LOV Oracle INV_MGD_MVT_ECONOMIC_ZONE Y select zone_code id, zone_display_name value, null description from mtl_economic_zones_vl where zone_code in (select zone_code from mtl_le_economic_zones where legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity ) order by zone_display_name Y US Economic Zone Economic Zone Code 7 30 :p_usage_type LOV Oracle INV_MGD_MVT_USAGE_TYPE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='MVT_USAGE_TYPES' and lookup_code in (select usage_type from mtl_stat_type_usages where legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone ) order by meaning Y US Usage Type Usage Type (Internal or External) 8 40 :p_stat_type LOV Oracle INV_MGD_MVT_STAT_TYPE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='MVT_STAT_TYPES' and lookup_code in (select stat_type from mtl_stat_type_usages where legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone and usage_type=:$flex$.inv_mgd_mvt_usage_type ) order by meaning Y US Statistical Type Statistic Type (Intrastat or Extrastat) 9 50 :p_movement_type LOV Oracle INV_MGD_MOVEMENT_TYPE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='MVT_MOVEMENT_TYPE' and enabled_flag='Y' order by meaning Y US Movement Type Movement type 10 60 :p_period_name LOV Oracle INV_MGD_MVT_PERIOD_NAME Y select period_name id, period_name value, null description from gl_periods where period_set_name in (select period_set_name from mtl_stat_type_usages where legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone and usage_type=:$flex$.inv_mgd_mvt_usage_type and stat_type=:$flex$.inv_mgd_mvt_stat_type ) and period_type in (select period_type from mtl_stat_type_usages where legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone and usage_type=:$flex$.inv_mgd_mvt_usage_type and stat_type=:$flex$.inv_mgd_mvt_stat_type ) and start_date>= (select gp.start_date from gl_periods gp ,mtl_stat_type_usages mstu where gp.period_name=mstu.start_period_name and gp.period_set_name=mstu.period_set_name and legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone and usage_type=:$flex$.inv_mgd_mvt_usage_type and stat_type=:$flex$.inv_mgd_mvt_stat_type ) and ((end_date<= (select gp.end_date from gl_periods gp ,mtl_stat_type_usages mstu where gp.period_name=mstu.end_period_name and gp.period_set_name=mstu.period_set_name and legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone and usage_type=:$flex$.inv_mgd_mvt_usage_type and stat_type=:$flex$.inv_mgd_mvt_stat_type )) or (exists (select null from mtl_stat_type_usages where legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone and usage_type=:$flex$.inv_mgd_mvt_usage_type and stat_type=:$flex$.inv_mgd_mvt_stat_type and end_period_name is null ) ) ) and adjustment_period_flag='N' order by start_date Y US Period Name Period name 11 70 :p_report_option LOV Oracle INV_MGD_REPORT_OPTION Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='INTRASTAT_REPORT_OPTION' and enabled_flag='Y' and language=userenv('LANG') order by meaning desc Y US Report Option Report type 12 80 :p_amount_display LOV Oracle INV_MGD_MVT_AMT_DISP Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='MVT_AMOUNT_DISPLAY' and enabled_flag='Y' and :$flex$.inv_srs_character='Y' order by meaning SELECT meaning FROM fnd_lookups WHERE lookup_type = 'MVT_AMOUNT_DISPLAY' AND lookup_code = 'C' US Amount Display Format Amount display format - normal currency precision or whole number 13 90 :p_currency_code LOV Oracle CST_SRS_CURRENCY_CODE Y select currency_code id, currency_code value, description description from fnd_currencies_vl where trunc(nvl(start_date_active,sysdate-1))<sysdate and trunc(nvl(end_date_active,sysdate+1))>sysdate order by value,description SELECT currency_code FROM gl_ledger_le_v WHERE legal_entity_id = :$flex$.legal_entity AND ledger_category_code = 'PRIMARY' Y US Currency Currency code 14 100 :p_exchange_rate_char LOV Oracle INV_MGD_MVT_EXCHANGE_RATE Y select actual_rate id, display_rate value, period description from cst_gl_translation_view where org_id=inv_mgd_mvt_utils_pkg.get_org_from_le (:$flex$.inv_mgd_mvt_legal_entity) and code=:$flex$.cst_srs_currency_code and inverse=:$flex$.cst_srs_inverse_rate and rate_type=:$flex$.cst_srs_rate_type order by period_year desc,period_num desc Y US Exchange Rate Exchange rate for movement statistics :$flex$.cst_srs_currency_code Currency Exchange Rate :$flex$.cst_srs_inverse_rate CST_SRS_INVERSE_RATE Exchange Rate :$flex$.cst_srs_rate_type CST_SRS_RATE_TYPE Exchange Rate :$flex$.inv_mgd_mvt_economic_zone Economic Zone Period Name :$flex$.inv_mgd_mvt_economic_zone Economic Zone Statistical Type :$flex$.inv_mgd_mvt_economic_zone Economic Zone Usage Type :$flex$.inv_mgd_mvt_legal_entity Legal Entity Economic Zone :$flex$.inv_mgd_mvt_legal_entity Legal Entity Exchange Rate :$flex$.inv_mgd_mvt_legal_entity Legal Entity Period Name :$flex$.inv_mgd_mvt_legal_entity Legal Entity Statistical Type :$flex$.inv_mgd_mvt_legal_entity Legal Entity Usage Type :$flex$.inv_mgd_mvt_stat_type Statistical Type Period Name :$flex$.inv_mgd_mvt_usage_type Usage Type Period Name :$flex$.inv_mgd_mvt_usage_type Usage Type Statistical Type :$flex$.inv_srs_character INV_SRS_CHARACTER Amount Display Format :$flex$.legal_entity Legal Entity Currency :$flex$.report_option Report Option INV_SRS_CHARACTER