[Home] [Help]
1827: FROM dual
1828: WHERE EXISTS
1829: (SELECT mtln.transaction_id
1830: FROM mtl_transaction_lot_numbers mtln,
1831: mtl_material_transactions mmt
1832: WHERE mtln.transaction_id = mmt.transaction_id
1833: AND mmt.inventory_item_id = p_item_id
1834: AND mmt.organization_id = p_org_id
1835: AND mtln.lot_number = p_lot_number
1848: D.DTL_UM,
1849: t.opm_costed_flag
1850: FROM gme_batch_header b,
1851: gme_material_details d,
1852: mtl_material_transactions t,
1853: mtl_transaction_lot_numbers l
1854: WHERE t.inventory_item_id = p_item_id
1855: AND t.organization_id = p_org_id
1856: AND T.TRANSACTION_SOURCE_TYPE_ID = 5
1892: CURSOR batch_txns
1893: IS
1894: SELECT SUM(mtln.primary_quantity),
1895: SUM(mtln.secondary_transaction_quantity)
1896: FROM mtl_material_transactions mmt ,
1897: mtl_transaction_lot_numbers mtln
1898: WHERE mmt.transaction_source_id = L_BATCH_ID
1899: AND mmt.transaction_source_type_id = 5
1900: AND NOT EXISTS
1995: P_FROM_BASE_UOM_FLAG VARCHAR2(10);
1996: --L_TO_CLASS VARCHAR2(30);
1997: L_TO_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1998:
1999: x_opm_costed_flag MTL_MATERIAL_TRANSACTIONS.OPM_COSTED_FLAG%TYPE ;
2000:
2001: P_TO_BASE_UOM_FLAG VARCHAR2(10);
2002: l_shelf_life_code number;
2003:
2082: BEGIN
2083:
2084: SELECT count(*)
2085: into L_PENDING_COUNT
2086: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
2087: WHERE INVENTORY_ITEM_ID = P_ITEM_ID;
2088:
2089: EXCEPTION
2090: WHEN NO_DATA_FOUND THEN
3025: BEGIN
3026:
3027: SELECT 1
3028: INTO L_PENDING_COUNT
3029: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
3030: WHERE MMTT.INVENTORY_ITEM_ID = P_ITEM_ID
3031: AND MMTT.ORGANIZATION_ID = P_ORG_ID
3032: AND EXISTS( SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP MTLT
3033: WHERE MTLT.TRANSACTION_TEMP_ID = MMTT.TRANSACTION_TEMP_ID