APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on RCV_SHIPMENT_LINES

Line 3468: , rcv_shipment_lines b

3464: , b.to_organization_id
3465: , c.project_id
3466: , c.task_id
3467: FROM rcv_transactions a
3468: , rcv_shipment_lines b
3469: , po_distributions_all c
3470: , mtl_units_of_measure d
3471: WHERE transaction_id = v_transaction_id
3472: AND a.shipment_line_id = b.shipment_line_id

Line 3512: , rcv_shipment_lines b

3508: , b.to_organization_id
3509: , c.project_id
3510: , c.task_id
3511: FROM rcv_transactions a
3512: , rcv_shipment_lines b
3513: , po_distributions_all c
3514: , mtl_units_of_measure d
3515: WHERE a.transaction_id = v_transaction_id
3516: AND a.source_document_code = 'PO'

Line 3543: , rcv_shipment_lines b

3539: , c.project_id
3540: , c.task_id
3541: , d.requisition_header_id
3542: FROM rcv_transactions a
3543: , rcv_shipment_lines b
3544: , po_req_distributions_all c
3545: , po_requisition_lines_all d
3546: , mtl_units_of_measure e
3547: WHERE a.transaction_id = v_transaction_id

Line 4447: /* Begin Bug 3688014 : If the rcv_shipment_lines contains a item revision

4443: mydebug(l_Fnd_Log_Message, c_api_name,9);
4444: END IF;
4445:
4446: ELSE
4447: /* Begin Bug 3688014 : If the rcv_shipment_lines contains a item revision
4448: for a non-revision controlled item, we should pass a NULL
4449: item revision to inventory so that supply gets updated accordingly.
4450: */
4451:

Line 4752: /* Begin Bug 3688014 : If the rcv_shipment_lines contains a item revision

4748: get_rcv_transaction_rec.item_revision := NULL;
4749: END;
4750:
4751: ELSE
4752: /* Begin Bug 3688014 : If the rcv_shipment_lines contains a item revision
4753: for a non-revision controlled item, we should pass a NULL
4754: item revision to inventory so that supply gets updated accordingly.
4755: */
4756: BEGIN

Line 4960: /* Begin Bug 3688014 : If the rcv_shipment_lines contains a item revision

4956: mydebug( 'Inside rev not null', c_api_name,9);
4957: mydebug( 'Item id :' || get_rcv_txn_int_req_rec.item_id, c_api_name,9);
4958: mydebug( 'Org :' || get_rcv_txn_int_req_rec.organization_id, c_api_name,9);
4959: END IF;
4960: /* Begin Bug 3688014 : If the rcv_shipment_lines contains a item revision
4961: for a non-revision controlled item, we should pass a NULL
4962: item revision to inventory so that supply gets updated accordingly.
4963: */
4964: --Bug 5147013: Changed the cursor name to get the