APPS.PO_CHG_REQUEST_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 3564: from RCV_TRANSACTIONS_INTERFACE rti

3560: -- l_po_change_requests(j).request_level='SHIPMENT' ) then
3561: IF(p_po_header_id IS NOT NULL AND p_po_release_id IS NOT NULL) THEN
3562: select count(*)
3563: into l_count_asn
3564: from RCV_TRANSACTIONS_INTERFACE rti
3565: where rti.TRANSACTION_TYPE = 'SHIP' and
3566: rti.PROCESSING_STATUS_CODE = 'PENDING' and
3567: rti.quantity > 0 and
3568: rti.PO_HEADER_ID = p_po_header_id and

Line 3574: from RCV_TRANSACTIONS_INTERFACE rti

3570: (rti.po_line_location_id = l_po_change_requests(j).document_line_location_id OR l_po_change_requests(j).document_line_location_id is null);
3571: ELSE
3572: select count(*)
3573: into l_count_asn
3574: from RCV_TRANSACTIONS_INTERFACE rti
3575: where rti.TRANSACTION_TYPE = 'SHIP' and
3576: rti.PROCESSING_STATUS_CODE = 'PENDING' and
3577: rti.quantity > 0 and
3578: rti.PO_HEADER_ID = p_po_header_id AND

Line 3786: FROM rcv_transactions_interface rti

3782: IF( l_po_change_requests(j).request_level = 'SHIPMENT' AND l_po_change_requests(j).action_type = 'MODIFICATION' ) THEN
3783: IF( p_po_header_id IS NOT NULL AND p_po_release_id IS NOT NULL ) THEN
3784: SELECT Count(*)
3785: INTO l_count_asn
3786: FROM rcv_transactions_interface rti
3787: WHERE rti.processing_status_code = 'PENDING'
3788: AND rti.quantity > 0
3789: AND rti.po_header_id = p_po_header_id
3790: AND rti.po_release_id (+) = p_po_release_id

Line 3795: FROM rcv_transactions_interface rti

3791: AND rti.po_line_location_id =l_po_change_requests(j).document_line_location_id;
3792: ELSE
3793: SELECT Count(*)
3794: INTO l_count_asn
3795: FROM rcv_transactions_interface rti
3796: WHERE rti.processing_status_code = 'PENDING'
3797: AND rti.quantity > 0
3798: AND rti.po_header_id = p_po_header_id
3799: AND rti.po_line_location_id =l_po_change_requests(j).document_line_location_id;

Line 3858: FROM rcv_transactions_interface rti

3854: LOOP
3855: IF( p_po_header_id IS NOT NULL AND p_po_release_id IS NOT NULL ) THEN
3856: SELECT Count(*)
3857: INTO l_count_asn
3858: FROM rcv_transactions_interface rti
3859: WHERE rti.processing_status_code = 'PENDING'
3860: AND rti.quantity > 0
3861: AND rti.po_header_id = p_po_header_id
3862: AND rti.po_release_id (+) = p_po_release_id

Line 3867: FROM rcv_transactions_interface rti

3863: AND rti.po_line_location_id = ship_rec.line_location_id;
3864: ELSE
3865: SELECT Count(*)
3866: INTO l_count_asn
3867: FROM rcv_transactions_interface rti
3868: WHERE rti.processing_status_code = 'PENDING'
3869: AND rti.quantity > 0
3870: AND rti.po_header_id = p_po_header_id
3871: AND rti.po_line_location_id = ship_rec.line_location_id;