APPS.GMF_LOT_COSTING_PUB dependencies on GME_BATCH_STEP_ITEMS

Line 1002: gme_batch_step_items gbsi,

998: gmd.cost_alloc
999: )
1000: FROM mtl_system_items_b iimb,
1001: mtl_material_transactions mmt,
1002: gme_batch_step_items gbsi,
1003: gme_material_details gmd,
1004: mtl_transaction_lot_numbers mtln,
1005: mtl_parameters mp,
1006: hr_organization_information hoi,

Line 1115: (SELECT material_detail_id FROM gme_batch_step_items

1111: AND iimb.organization_id = mmt.organization_id
1112: AND gmd.batch_id = p_batch_id
1113: AND mmt.trx_source_line_id = gmd.material_detail_id
1114: AND gmd.material_detail_id NOT IN
1115: (SELECT material_detail_id FROM gme_batch_step_items
1116: WHERE batch_id = p_batch_id)
1117: GROUP BY
1118: -- decode(is_item_lot_costed(iimb.organization_id,iimb.inventory_item_id), iimb.inventory_item_id,
1119: -- mmt.transaction_id,

Line 1191: (SELECT material_detail_id FROM gme_batch_step_items

1187: AND iimb.organization_id = mmt.organization_id
1188: AND gmd.batch_id = p_batch_id
1189: AND mmt.trx_source_line_id = gmd.material_detail_id
1190: AND gmd.material_detail_id NOT IN
1191: (SELECT material_detail_id FROM gme_batch_step_items
1192: WHERE batch_id = p_batch_id);
1193:
1194:
1195: CURSOR materials_cursor_nr

Line 1677: FROM gme_material_details gmd, gme_batch_step_items gbsi

1673: --**********************************************************************************************
1674: CURSOR associated_batch_steps_cursor(p_batch_id NUMBER)
1675: IS
1676: SELECT DISTINCT gbsi.batchstep_id
1677: FROM gme_material_details gmd, gme_batch_step_items gbsi
1678: WHERE gmd.material_detail_id = gbsi.material_detail_id
1679: AND gmd.batch_id = gbsi.batch_id
1680: AND gmd.line_type = 1
1681: AND gmd.batch_id = p_batch_id;

Line 5433: FROM gme_material_details gmd, gme_batch_step_items gbsi

5429: /* Check whether the number of Distinct steps having step material association is 1.
5430: If not don't use Cost Allocation Factor */
5431: SELECT COUNT (DISTINCT batchstep_id)
5432: INTO l_count
5433: FROM gme_material_details gmd, gme_batch_step_items gbsi
5434: WHERE gmd.material_detail_id = gbsi.material_detail_id
5435: AND gmd.batch_id = gbsi.batch_id
5436: AND gmd.line_type = 1
5437: AND gmd.batch_id = transaction_row.doc_id;

Line 5464: FROM gme_batch_step_items

5460: AND gmd.batch_id =transaction_row.doc_id
5461: AND mmt.trx_source_line_id = gmd.material_detail_id
5462: AND gmd.material_detail_id NOT IN (
5463: SELECT material_detail_id
5464: FROM gme_batch_step_items
5465: WHERE batch_id = transaction_row.doc_id);
5466:
5467: IF l_debug_level >= l_debug_level_high THEN
5468: fnd_file.put_line (fnd_file.log, ' Cost Allocation Factor : The number of unassociated products are '||l_unassociated_prds);