DBA Data[Home] [Help]

APPS.GMF_LOT_COSTING_PUB dependencies on GME_TRANSACTION_PAIRS

Line 841: gme_transaction_pairs gtp

837: gme_material_details gmd,
838: mtl_transaction_lot_numbers mtln,
839: mtl_parameters mp,
840: hr_organization_information hoi,
841: gme_transaction_pairs gtp
842: WHERE gbsi.batch_id = p_batch_id
843: AND gbsi.batchstep_id = p_batchstep_id
844: AND mp.organization_id = mmt.organization_id
845: AND hoi.organization_id = mmt.organization_id

Line 992: gme_transaction_pairs gtp

988: FROM mtl_system_items_b iimb,
989: mtl_material_transactions mmt,
990: gme_material_details gme,
991: mtl_transaction_lot_numbers mtln,
992: gme_transaction_pairs gtp
993: WHERE mmt.trx_source_line_id = gme.material_detail_id
994: AND gme.batch_id = p_batch_id
995: AND mmt.transaction_quantity <> 0
996: AND mmt.inventory_item_id = iimb.inventory_item_id

Line 8679: gme_transaction_pairs gtp,

8675: mmt.transfer_organization_id
8676: FROM mtl_material_transactions mmt,
8677: gme_material_details gme,
8678: mtl_transaction_lot_numbers mtln,
8679: gme_transaction_pairs gtp,
8680: gmf_process_organizations_gt gpo,
8681: gmf_lot_costed_items_gt lcig
8682: WHERE
8683: gpo.organization_id = mmt.organization_id