APPS.WIP_BFLPROC_PRIV dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 258: from mtl_material_transactions_temp mmtt

254:
255: cursor c_checkExistingMMTT(x_opSeqNum NUMBER, x_inventoryItemID NUMBER,
256: x_txnActionID NUMBER, x_txnTypeID NUMBER) IS
257: select 1
258: from mtl_material_transactions_temp mmtt
259: where mmtt.transaction_source_id = p_wipEntityID
260: and mmtt.organization_id = p_orgID
261: and mmtt.operation_seq_num = x_opSeqNum
262: and mmtt.inventory_item_id = x_inventoryItemID

Line 2727: UPDATE mtl_material_transactions_temp mmtt

2723:
2724: -- Insert all necessary info that need to be used by inventory form to
2725: -- gather lot/serial from the user
2726: IF(x_bfRequired = WIP_CONSTANTS.WBF_BF_PAGE)THEN
2727: UPDATE mtl_material_transactions_temp mmtt
2728: SET (mmtt.item_segments,
2729: mmtt.item_description,
2730: mmtt.item_trx_enabled_flag,
2731: mmtt.item_location_control_code,

Line 2773: UPDATE mtl_material_transactions_temp mmtt

2769: * routing. We should seperate statement to set mmtt.department_code
2770: * from statement to update other columns.
2771: */
2772: -- set department code if mmtt.department_id is not null
2773: UPDATE mtl_material_transactions_temp mmtt
2774: SET (mmtt.department_code)
2775: =
2776: (SELECT bd.department_code
2777: FROM bom_departments bd

Line 2789: UPDATE mtl_material_transactions_temp mmtt

2785: IF(l_lot_entry_type IN (WIP_CONSTANTS.RECDATE_FULL,
2786: WIP_CONSTANTS.EXPDATE_FULL,
2787: WIP_CONSTANTS.TXNHISTORY_FULL)) THEN
2788:
2789: UPDATE mtl_material_transactions_temp mmtt
2790: SET mmtt.lot_number =
2791: ( SELECT mtlt.lot_number
2792: FROM mtl_transaction_lots_temp mtlt
2793: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 2808: FROM mtl_material_transactions_temp mmtt,

2804: /* Bug 6342487 - FP of Bug 6111292 - Moved this delete statement from below */
2805: DELETE FROM mtl_transaction_lots_temp mtlt
2806: WHERE EXISTS
2807: (SELECT 'x'
2808: FROM mtl_material_transactions_temp mmtt,
2809: wip_entities we
2810: WHERE mmtt.transaction_header_id = p_txnHdrID
2811: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
2812: AND mmtt.transaction_source_id = we.wip_entity_id

Line 2827: FROM mtl_material_transactions_temp mmtt,

2823: /*
2824: DELETE FROM mtl_transaction_lots_temp mtlt
2825: WHERE mtlt.transaction_temp_id =
2826: ( SELECT mmtt.transaction_temp_id
2827: FROM mtl_material_transactions_temp mmtt,
2828: wip_entities we
2829: WHERE mmtt.transaction_header_id = p_txnHdrID
2830: AND 1 = ( SELECT count(*)
2831: FROM mtl_transaction_lots_temp mtlt

Line 2845: FROM mtl_material_transactions_temp mmtt,

2841: there is no need to delete since the component rows will not be visible in the UI.
2842: DELETE FROM mtl_transaction_lots_temp mtlt
2843: WHERE EXISTS
2844: (SELECT 'x'
2845: FROM mtl_material_transactions_temp mmtt,
2846: wip_entities we
2847: WHERE mmtt.transaction_header_id = p_txnHdrID
2848: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
2849: AND mmtt.transaction_source_id = we.wip_entity_id

Line 2864: UPDATE mtl_material_transactions_temp mmtt

2860: -- we can derive. If it is not equal to required quantity, user need to provide
2861: -- more lot/serial information.
2862: /*
2863: -- Only update transaction_quantity for item under lot/serial.
2864: UPDATE mtl_material_transactions_temp mmtt
2865: SET mmtt.transaction_quantity =
2866: (SELECT NVL(SUM(mtlt.transaction_quantity),0)
2867: FROM mtl_transaction_lots_temp mtlt
2868: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id)