APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on OPI_DBI_ORG_LE_TEMP

Line 384: opi_dbi_org_le_temp tmp, --Bug 4768058

380: sum(txn_base_value) onhand_value_b,
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'

Line 410: opi_dbi_org_le_temp tmp --Bug 4768058

406: 0 onhand_value_b,
407: sum(txn_base_value) onhand_value_b_draft,
408: gtv.accounted_flag
409: FROM gmf_transaction_valuation gtv,
410: opi_dbi_org_le_temp tmp --Bug 4768058
411: WHERE gtv.journal_line_type IN ('INV')
412: --AND gtv.transaction_source = 'INVENTORY' --bug 4870029
413: and gtv.ledger_id = tmp.ledger_id--Bug 4768058
414: and gtv.legal_entity_id = tmp.legal_entity_id

Line 810: opi_dbi_org_le_temp tmp,--Bug 4760483

806: (SELECT transaction_id,
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'

Line 831: opi_dbi_org_le_temp tmp --Bug 4760483

827: select transaction_id,
828: sum(txn_base_value) base_transaction_value ,
829: accounted_flag
830: from gmf_transaction_valuation gtv,
831: opi_dbi_org_le_temp tmp --Bug 4760483
832: where --gtv.transaction_source = 'INVENTORY' and --bug 4870029
833: gtv.journal_line_type = 'ITR'
834: and gtv.ledger_id = tmp.ledger_id --Bug 4760483
835: and gtv.legal_entity_id = tmp.legal_entity_id

Line 1073: opi_dbi_org_le_temp tmp,--Bug 4768058

1069: gmdtl.cost_alloc)) wip_value_b,
1070: 0 wip_value_b_draft
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'

Line 1106: opi_dbi_org_le_temp tmp,--Bug 4760483

1102: 2, gmdtl.cost_alloc,
1103: gmdtl.cost_alloc)) wip_value_b_draft
1104: FROM
1105: gmf_transaction_valuation gtv,
1106: opi_dbi_org_le_temp tmp,--Bug 4760483
1107: gme_material_details gmdtl
1108: WHERE gtv.journal_line_type = 'WIP'
1109: AND gtv.accounted_flag = 'D' --
1110: AND gtv.doc_id = gmdtl.batch_id