APPS.WIP_BFLPROC_PRIV dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 2901: FROM mtl_transaction_lots_temp mtlt

2897:
2898: UPDATE mtl_material_transactions_temp mmtt
2899: SET mmtt.lot_number =
2900: ( SELECT mtlt.lot_number
2901: FROM mtl_transaction_lots_temp mtlt
2902: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id
2903: AND 1 = ( SELECT count(*)
2904: FROM mtl_transaction_lots_temp mtlt
2905: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id)

Line 2904: FROM mtl_transaction_lots_temp mtlt

2900: ( SELECT mtlt.lot_number
2901: FROM mtl_transaction_lots_temp mtlt
2902: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id
2903: AND 1 = ( SELECT count(*)
2904: FROM mtl_transaction_lots_temp mtlt
2905: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id)
2906: )
2907: WHERE mmtt.transaction_header_id = p_txnHdrID
2908: AND mmtt.transaction_action_id IN (WIP_CONSTANTS.ISSCOMP_ACTION,

Line 2914: DELETE FROM mtl_transaction_lots_temp mtlt

2910: WIP_CONSTANTS.ISSNEGC_ACTION,
2911: WIP_CONSTANTS.RETNEGC_ACTION);
2912:
2913: /* Bug 6342487 - FP of Bug 6111292 - Moved this delete statement from below */
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

Line 2924: FROM mtl_transaction_lots_temp mtlt2

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
2923: AND 1 = (SELECT count(*)
2924: FROM mtl_transaction_lots_temp mtlt2
2925: WHERE mtlt2.transaction_temp_id =
2926: mtlt.transaction_temp_id
2927: ));
2928: END IF;

Line 2933: DELETE FROM mtl_transaction_lots_temp mtlt

2929: /* Fixed bug 4121977. One transaction header ID can have multiple temp ID.
2930: This cause select count(*) to throw single-row subquery returns more
2931: than one row exception. */
2932: /*
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

Line 2940: FROM mtl_transaction_lots_temp mtlt

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 =
2942: mtlt.transaction_temp_id
2943: )
2944: AND mmtt.transaction_source_id = we.wip_entity_id

Line 2951: DELETE FROM mtl_transaction_lots_temp mtlt

2947: */
2948: /* Bug 6342487 - FP of Bug 6111292 - Moved this delete statement above inside the IF condition. The rows should be deleted from MTLT
2949: only for the case of Lot Verification=All after the lot has been stamped on MMTT. For Lot Verification=Exception Only
2950: there is no need to delete since the component rows will not be visible in the UI.
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

Line 2961: FROM mtl_transaction_lots_temp mtlt2

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
2960: AND 1 = (SELECT count(*)
2961: FROM mtl_transaction_lots_temp mtlt2
2962: WHERE mtlt2.transaction_temp_id =
2963: mtlt.transaction_temp_id
2964: ));
2965: */

Line 2976: FROM mtl_transaction_lots_temp mtlt

2972: -- Only update transaction_quantity for item under lot/serial.
2973: UPDATE mtl_material_transactions_temp mmtt
2974: SET mmtt.transaction_quantity =
2975: (SELECT NVL(SUM(mtlt.transaction_quantity),0)
2976: FROM mtl_transaction_lots_temp mtlt
2977: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id)
2978: WHERE mmtt.transaction_header_id = p_txnHdrID
2979: AND (mmtt.item_serial_control_code IN(WIP_CONSTANTS.FULL_SN,
2980: WIP_CONSTANTS.DYN_RCV_SN)