[Home] [Help]
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,
1007: gme_transaction_pairs gtp
1095: gmd.actual_qty,
1096: gmd.dtl_um, gmd.cost_alloc
1097: FROM mtl_system_items_b iimb,
1098: mtl_material_transactions mmt,
1099: gme_material_details gmd,
1100: mtl_transaction_lot_numbers mtln,
1101: mtl_parameters mp,
1102: hr_organization_information hoi
1103: WHERE mmt.transaction_source_type_id = 5
1173: gmd.cost_alloc
1174: )
1175: FROM mtl_system_items_b iimb,
1176: mtl_material_transactions mmt,
1177: gme_material_details gmd,
1178: mtl_transaction_lot_numbers mtln,
1179: hr_organization_information hoi
1180: WHERE mmt.transaction_source_type_id = 5
1181: AND gmd.line_type = 1
1218: gme.cost_alloc
1219: )
1220: FROM mtl_system_items_b iimb,
1221: mtl_material_transactions mmt,
1222: gme_material_details gme,
1223: mtl_transaction_lot_numbers mtln,
1224: gme_transaction_pairs gtp
1225: WHERE mmt.trx_source_line_id = gme.material_detail_id
1226: AND mmt.transaction_source_type_id = 5 /* Rajesh B8290451 */
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;
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;
5451:
5452:
5453: SELECT COUNT (DISTINCT mmt.inventory_item_id)
5454: INTO l_unassociated_prds
5455: FROM mtl_material_transactions mmt, gme_material_details gmd
5456: WHERE mmt.transaction_source_type_id = 5
5457: AND mmt.transaction_source_id = gmd.batch_id
5458: AND gmd.line_type = 1
5459: AND mmt.transaction_quantity <> 0
10421: 1, mmt.transaction_id ,
10422: DECODE(Decode(nvl(gtp.pair_type,0),1,gtp.transaction_id2,NULL), NULL, mmt.transaction_id, (Decode(nvl(gtp.pair_type,0),1,gtp.transaction_id2,NULL)+.5))),mmt.transaction_id) as oc3,
10423: NVL(gbh.routing_id, 0) as routing_id
10424: FROM mtl_material_transactions mmt,
10425: gme_material_details gme,
10426: mtl_transaction_lot_numbers mtln,
10427: (Select pair_type, transaction_id1, transaction_id2 From gme_transaction_pairs where pair_type = 1) gtp, -- PK Bug 9069363
10428: gmf_process_organizations_gt gpo,
10429: gme_batch_header gbh,
10449: AND gmlct.cost_type_id = l_cost_type_id
10450: AND gmlct.lot_number = mtln.lot_number
10451: AND gmlct.final_cost_flag = 1)
10452: AND gme.phantom_type IN (select (decode(phantom_type,1,1,0))
10453: from gme_material_details gme1 where mmt.trx_source_line_id = gme1.material_detail_id)
10454: UNION ALL
10455: SELECT
10456: mmt.transaction_source_id as doc_id,
10457: mmt.transaction_source_type_id,
10796: 1, mmt.transaction_id ,
10797: DECODE(Decode(nvl(gtp.pair_type,0),1,gtp.transaction_id2,NULL), NULL, mmt.transaction_id, (Decode(nvl(gtp.pair_type,0),1,gtp.transaction_id2,NULL)+.5))),mmt.transaction_id) as oc3,
10798: NVL(gbh.routing_id, 0) as routing_id
10799: FROM mtl_material_transactions mmt,
10800: gme_material_details gme,
10801: mtl_transaction_lot_numbers mtln,
10802: (Select pair_type, transaction_id1, transaction_id2 From gme_transaction_pairs where pair_type = 1) gtp, -- PK Bug 9069363
10803: gmf_process_organizations_gt gpo,
10804: gme_batch_header gbh,
10825: AND gmlct.cost_type_id = l_cost_type_id
10826: AND gmlct.lot_number = mtln.lot_number
10827: AND gmlct.final_cost_flag = 1)
10828: AND gme.phantom_type IN (select (decode(phantom_type,1,1,0))
10829: from gme_material_details gme1 where mmt.trx_source_line_id = gme1.material_detail_id)
10830: UNION ALL
10831: SELECT
10832: mmt.transaction_source_id as doc_id,
10833: mmt.transaction_source_type_id,