eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on OPI_DBI_CONC_PROG_RUN_LOG

Line 259: opi_dbi_conc_prog_run_log prl,

255: trunc(mta.transaction_date) transaction_date,
256: sum(mta.base_transaction_value) base_transaction_value
257: FROM mtl_transaction_accounts mta,
258: mtl_material_transactions mmt3,
259: opi_dbi_conc_prog_run_log prl,
260: mtl_parameters mp
261: WHERE mta.accounting_line_type = 1
262: AND mta.transaction_id >= prl.from_bound_id
263: AND mta.transaction_id < to_bound_id

Line 292: opi_dbi_conc_prog_run_log prl

288: trunc(mmt.transaction_date) transaction_date,
289: nvl(sum(decode(mmt.transaction_action_id,24,0,mmt.primary_quantity)),0) onhand_qty
290: FROM mtl_material_transactions mmt,
291: mtl_parameters mp,
292: opi_dbi_conc_prog_run_log prl
293: WHERE prl.etl_type = 'INVENTORY'
294: AND prl.load_type = 'INCR'
295: AND prl.driving_table_code = 'MMT'
296: AND mmt.organization_id = prl.bound_level_entity_id

Line 385: opi_dbi_conc_prog_run_log prl

381: 0 onhand_value_b_draft,
382: gtv.accounted_flag
383: FROM gmf_transaction_valuation gtv,
384: opi_dbi_org_le_temp tmp, --Bug 4768058
385: opi_dbi_conc_prog_run_log prl
386: WHERE prl.driving_table_code = 'GTV'
387: AND prl.load_type = 'INCR'
388: AND prl.etl_type = 'INVENTORY'
389: AND gtv.journal_line_type = 'INV'

Line 480: from OPI_DBI_CONC_PROG_RUN_LOG log

476:
477: BEGIN
478:
479: select min(FROM_BOUND_ID) into from_mta_id --USED IN DISCRETE QUERY
480: from OPI_DBI_CONC_PROG_RUN_LOG log
481: where log.driving_table_code= 'MMT'
482: And log.etl_type = 'INVENTORY'
483: and FROM_BOUND_ID IS NOT NULL
484: And log.load_type= 'INCR';

Line 500: from OPI_DBI_CONC_PROG_RUN_LOG log

496:
497: BEGIN
498:
499: select Max(TO_BOUND_ID) into to_mta_id -- USED IN DISCRETE QUERY
500: from OPI_DBI_CONC_PROG_RUN_LOG log
501: where log.driving_table_code= 'MMT'
502: And log.etl_type = 'INVENTORY'
503: And log.load_type= 'INCR';
504: EXCEPTION

Line 637: OPI_DBI_CONC_PROG_RUN_LOG col,

633: ANd transaction_id < to_mta_id
634: group by transaction_id) mta,
635: mtl_system_items msi_fm,
636: mtl_system_items msi_to,
637: OPI_DBI_CONC_PROG_RUN_LOG col,
638: MTL_PARAMETERS mp
639: WHERE mmt1.organization_id = mip.from_organization_id
640: AND mmt1.transfer_organization_id = mip.to_organization_id
641: AND mmt1.transaction_action_id in (15,12,22,21)

Line 681: OPI_DBI_CONC_PROG_RUN_LOG col

677: trunc(mmt1.transaction_date) trx_date
678: FROM mtl_material_transactions mmt1,
679: mtl_transaction_accounts mta,
680: mtl_system_items msi_fm,
681: OPI_DBI_CONC_PROG_RUN_LOG col
682: WHERE mmt1.transaction_action_id = 24
683: AND mta.transaction_id = mmt1.transaction_id
684: AND mmt1.organization_id = mta.organization_id
685: AND mta.accounting_line_type = 14

Line 811: opi_dbi_conc_prog_run_log col

807: sum(txn_base_value) base_transaction_value
808: ,accounted_flag
809: FROM gmf_transaction_valuation gtv,
810: opi_dbi_org_le_temp tmp,--Bug 4760483
811: opi_dbi_conc_prog_run_log col
812: WHERE --gtv.transaction_source = 'INVENTORY' AND -- bug 4870029
813: gtv.journal_line_type = 'ITR'
814: and col.driving_table_code='GTV'
815: and col.etl_type= 'INVENTORY'

Line 963: Opi_dbi_conc_prog_run_log prl,

959: trunc (mta.transaction_date) transaction_date,
960: sum (nvl (mta.base_transaction_value,0)) wip_value
961: FROM
962: mtl_transaction_accounts mta,
963: Opi_dbi_conc_prog_run_log prl,
964: wip_entities we
965: WHERE
966: prl.driving_table_code = 'MMT'
967: AND prl.load_type = 'INCR'

Line 990: Opi_dbi_conc_prog_run_log prl,

986: trunc (wta.transaction_date) transaction_date,
987: sum (nvl (wta.base_transaction_value,0)) wip_value
988: FROM
989: wip_transaction_accounts wta,
990: Opi_dbi_conc_prog_run_log prl,
991: wip_entities we
992: WHERE
993: prl.driving_table_code = 'WTA'
994: AND prl.load_type = 'INCR'

Line 1075: opi_dbi_conc_prog_run_log prl

1071: FROM
1072: gmf_transaction_valuation gtv,
1073: opi_dbi_org_le_temp tmp,--Bug 4768058
1074: gme_material_details gmdtl,
1075: opi_dbi_conc_prog_run_log prl
1076: WHERE prl.driving_table_code = 'GTV'
1077: AND prl.load_type = 'INCR'
1078: AND prl.etl_type = 'INVENTORY'
1079: AND gtv.journal_line_type = 'WIP'