APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on RCV_SHIPMENT_LINES

Line 3471: , rcv_shipment_lines b

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

Line 3519: , rcv_shipment_lines b

3515: , b.to_organization_id
3516: , c.project_id
3517: , c.task_id
3518: FROM rcv_transactions a
3519: , rcv_shipment_lines b
3520: , po_distributions_all c
3521: , mtl_units_of_measure d
3522: WHERE a.transaction_id = v_transaction_id
3523: AND a.source_document_code = 'PO'

Line 3554: , rcv_shipment_lines b

3550: , c.project_id
3551: , c.task_id
3552: , d.requisition_header_id
3553: FROM rcv_transactions a
3554: , rcv_shipment_lines b
3555: , po_req_distributions_all c
3556: , po_requisition_lines_all d
3557: , mtl_units_of_measure e
3558: WHERE a.transaction_id = v_transaction_id

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

4527: mydebug(l_Fnd_Log_Message, c_api_name,9);
4528: END IF;
4529:
4530: ELSE
4531: /* Begin Bug 3688014 : If the rcv_shipment_lines contains a item revision
4532: for a non-revision controlled item, we should pass a NULL
4533: item revision to inventory so that supply gets updated accordingly.
4534: */
4535:

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

4857: get_rcv_transaction_rec.item_revision := NULL;
4858: END;
4859:
4860: ELSE
4861: /* Begin Bug 3688014 : If the rcv_shipment_lines contains a item revision
4862: for a non-revision controlled item, we should pass a NULL
4863: item revision to inventory so that supply gets updated accordingly.
4864: */
4865: BEGIN

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

5170: mydebug( 'Inside rev not null', c_api_name,9);
5171: mydebug( 'Item id :' || get_rcv_txn_int_req_rec.item_id, c_api_name,9);
5172: mydebug( 'Org :' || get_rcv_txn_int_req_rec.organization_id, c_api_name,9);
5173: END IF;
5174: /* Begin Bug 3688014 : If the rcv_shipment_lines contains a item revision
5175: for a non-revision controlled item, we should pass a NULL
5176: item revision to inventory so that supply gets updated accordingly.
5177: */
5178: --Bug 5147013: Changed the cursor name to get the