[Home] [Help]
2699: WIP_CONSTANTS.RETNEGC_ACTION)
2700: AND (mti.MOVE_TRANSACTION_ID = p_movTxnID OR mti.COMPLETION_TRANSACTION_ID = p_cplTxnID)
2701: AND EXISTS (SELECT 1
2702: FROM wip_requirement_operations wro
2703: ,wip_entities we
2704: WHERE wro.wip_entity_id = mti.transaction_source_id
2705: AND wro.organization_id = mti.organization_id
2706: AND wro.wip_entity_id = we.wip_entity_id
2707: AND wro.inventory_item_id = mti.inventory_item_id
2749: WIP_CONSTANTS.ISSNEGC_ACTION,
2750: WIP_CONSTANTS.RETNEGC_ACTION)
2751: AND EXISTS (SELECT 1
2752: FROM wip_requirement_operations wro
2753: ,wip_entities we
2754: WHERE wro.wip_entity_id = mti.transaction_source_id
2755: AND wro.organization_id = mti.organization_id
2756: AND wro.wip_entity_id = we.wip_entity_id
2757: AND wro.inventory_item_id = mti.inventory_item_id
2914: DELETE FROM mtl_transaction_lots_temp mtlt
2915: WHERE EXISTS
2916: (SELECT 'x'
2917: FROM mtl_material_transactions_temp mmtt,
2918: wip_entities we
2919: WHERE mmtt.transaction_header_id = p_txnHdrID
2920: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
2921: AND mmtt.transaction_source_id = we.wip_entity_id
2922: AND we.entity_type = wip_constants.lotbased
2933: DELETE FROM mtl_transaction_lots_temp mtlt
2934: WHERE mtlt.transaction_temp_id =
2935: ( SELECT mmtt.transaction_temp_id
2936: FROM mtl_material_transactions_temp mmtt,
2937: wip_entities we
2938: WHERE mmtt.transaction_header_id = p_txnHdrID
2939: AND 1 = ( SELECT count(*)
2940: FROM mtl_transaction_lots_temp mtlt
2941: WHERE mmtt.transaction_temp_id =
2951: DELETE FROM mtl_transaction_lots_temp mtlt
2952: WHERE EXISTS
2953: (SELECT 'x'
2954: FROM mtl_material_transactions_temp mmtt,
2955: wip_entities we
2956: WHERE mmtt.transaction_header_id = p_txnHdrID
2957: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
2958: AND mmtt.transaction_source_id = we.wip_entity_id
2959: AND we.entity_type = wip_constants.lotbased