APPS.INV_RCV_STD_RCPT_APIS dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 2323: UPDATE mtl_transaction_lots_interface

2319: IF (l_debug = 1) THEN
2320: print_debug('create_po_rcpt_intf_rec 130.6: serial_control_code IS 6, need TO NULL OUT mtli', 4);
2321: END IF;
2322: BEGIN
2323: UPDATE mtl_transaction_lots_interface
2324: SET serial_transaction_temp_id = NULL
2325: WHERE product_transaction_id = p_original_rti_id
2326: AND product_code = 'RCV';
2327: EXCEPTION

Line 3015: UPDATE mtl_transaction_lots_interface

3011: AND product_code = 'RCV';
3012: END IF;
3013:
3014: IF l_msni_count = 0 THEN
3015: UPDATE mtl_transaction_lots_interface
3016: SET serial_transaction_temp_id = NULL
3017: WHERE product_transaction_id = p_original_rti_id
3018: AND product_code = 'RCV';
3019: END IF;

Line 4656: UPDATE mtl_transaction_lots_interface

4652: AND product_code = 'RCV';
4653: END IF;
4654:
4655: IF l_msni_count = 0 THEN
4656: UPDATE mtl_transaction_lots_interface
4657: SET serial_transaction_temp_id = NULL
4658: WHERE product_transaction_id = p_original_rti_id
4659: AND product_code = 'RCV';
4660: END IF;

Line 9265: FROM mtl_transaction_lots_interface mtli,

9261:
9262: BEGIN
9263: SELECT NVL(SUM(mtli.primary_quantity),0)
9264: INTO l_mtli_primary_quantity
9265: FROM mtl_transaction_lots_interface mtli,
9266: rcv_transactions_interface rti
9267: WHERE rti.processing_status_code <> 'ERROR'
9268: AND rti.transaction_status_code <> 'ERROR'
9269: AND rti.to_organization_id = p_rcv_org_id

Line 9287: FROM mtl_transaction_lots_interface

9283: IF (p_product_txn_id IS NOT NULL) THEN
9284: BEGIN
9285: SELECT Nvl(SUM(primary_quantity),0)
9286: INTO l_current_grp_prim_qty
9287: FROM mtl_transaction_lots_interface
9288: WHERE product_transaction_id = p_product_txn_id
9289: AND lot_number = p_lot_number
9290: AND product_code = 'RCV';
9291: EXCEPTION

Line 9384: FROM mtl_transaction_lots_interface mtli,

9380:
9381: BEGIN
9382: SELECT NVL(SUM(mtli.primary_quantity),0)
9383: INTO l_mtli_primary_quantity
9384: FROM mtl_transaction_lots_interface mtli,
9385: rcv_transactions_interface rti
9386: WHERE rti.processing_status_code <> 'ERROR'
9387: AND rti.transaction_status_code <> 'ERROR'
9388: AND rti.to_organization_id = p_rcv_org_id

Line 9407: FROM mtl_transaction_lots_interface

9403: IF (p_product_txn_id IS NOT NULL) THEN
9404: BEGIN
9405: SELECT Nvl(SUM(primary_quantity),0)
9406: INTO l_current_grp_prim_qty
9407: FROM mtl_transaction_lots_interface
9408: WHERE product_transaction_id = p_product_txn_id
9409: AND lot_number = p_lot_number
9410: AND product_code = 'RCV';
9411: EXCEPTION