APPS.GMF_LOT_COSTING_PUB dependencies on GME_MATERIAL_DETAILS

Line 837: gme_material_details gmd,

833: )
834: FROM mtl_system_items_b iimb,
835: mtl_material_transactions mmt,
836: gme_batch_step_items gbsi,
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

Line 901: gme_material_details gmd,

897: gmd.cost_alloc
898: )
899: FROM mtl_system_items_b iimb,
900: mtl_material_transactions mmt,
901: gme_material_details gmd,
902: mtl_transaction_lot_numbers mtln,
903: mtl_parameters mp,
904: hr_organization_information hoi
905: WHERE mmt.transaction_source_type_id = 5

Line 947: gme_material_details gmd,

943: gmd.cost_alloc
944: )
945: FROM mtl_system_items_b iimb,
946: mtl_material_transactions mmt,
947: gme_material_details gmd,
948: mtl_transaction_lot_numbers mtln,
949: hr_organization_information hoi
950: WHERE mmt.transaction_source_type_id = 5
951: AND gmd.line_type = 1

Line 990: gme_material_details gme,

986: gme.cost_alloc
987: )
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

Line 1371: FROM gme_material_details gmd, gme_batch_step_items gbsi

1367: --**********************************************************************************************
1368: CURSOR associated_batch_steps_cursor(p_batch_id NUMBER)
1369: IS
1370: SELECT DISTINCT gbsi.batchstep_id
1371: FROM gme_material_details gmd, gme_batch_step_items gbsi
1372: WHERE gmd.material_detail_id = gbsi.material_detail_id
1373: AND gmd.batch_id = gbsi.batch_id
1374: AND gmd.line_type = 1
1375: AND gmd.batch_id = p_batch_id;

Line 5031: FROM gme_material_details gmd, gme_batch_step_items gbsi

5027: /* Check whether the number of Distinct steps having step material association is 1.
5028: If not don't use Cost Allocation Factor */
5029: SELECT COUNT (DISTINCT batchstep_id)
5030: INTO l_count
5031: FROM gme_material_details gmd, gme_batch_step_items gbsi
5032: WHERE gmd.material_detail_id = gbsi.material_detail_id
5033: AND gmd.batch_id = gbsi.batch_id
5034: AND gmd.line_type = 1
5035: AND gmd.batch_id = transaction_row.doc_id;

Line 5056: FROM mtl_material_transactions mmt, gme_material_details gmd

5052:
5053:
5054: SELECT COUNT (DISTINCT mmt.inventory_item_id)
5055: INTO l_unassociated_prds
5056: FROM mtl_material_transactions mmt, gme_material_details gmd
5057: WHERE mmt.transaction_source_type_id = 5
5058: AND mmt.transaction_source_id = gmd.batch_id
5059: AND gmd.line_type = 1
5060: AND mmt.transaction_quantity <> 0

Line 8677: gme_material_details gme,

8673: mmt.transfer_transaction_id,
8674: NVL(mmt.transaction_cost,0),
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