APPS.GMF_LOT_COSTING_PUB dependencies on GME_BATCH_STEP_ITEMS

Line 836: gme_batch_step_items gbsi,

832: gmd.cost_alloc
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,

Line 917: (SELECT material_detail_id FROM gme_batch_step_items

913: AND iimb.organization_id = mmt.organization_id
914: AND gmd.batch_id = p_batch_id
915: AND mmt.trx_source_line_id = gmd.material_detail_id
916: AND gmd.material_detail_id NOT IN
917: (SELECT material_detail_id FROM gme_batch_step_items
918: WHERE batch_id = p_batch_id);
919:
920:
921:

Line 961: (SELECT material_detail_id FROM gme_batch_step_items

957: AND iimb.organization_id = mmt.organization_id
958: AND gmd.batch_id = p_batch_id
959: AND mmt.trx_source_line_id = gmd.material_detail_id
960: AND gmd.material_detail_id NOT IN
961: (SELECT material_detail_id FROM gme_batch_step_items
962: WHERE batch_id = p_batch_id);
963:
964:
965: CURSOR materials_cursor_nr

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 5065: FROM gme_batch_step_items

5061: AND gmd.batch_id =transaction_row.doc_id
5062: AND mmt.trx_source_line_id = gmd.material_detail_id
5063: AND gmd.material_detail_id NOT IN (
5064: SELECT material_detail_id
5065: FROM gme_batch_step_items
5066: WHERE batch_id = transaction_row.doc_id);
5067:
5068: IF l_debug_level >= l_debug_level_high
5069: THEN