APPS.RCV_DCP_PVT dependencies on RCV_HEADERS_INTERFACE

Line 639: FROM rcv_headers_interface rhi, rcv_shipment_headers rsh

635: , rhi.receipt_source_code
636: , rhi.asn_type rhi_asn_type
637: , rsh.asn_type rsh_asn_type
638: , rhi.creation_date
639: FROM rcv_headers_interface rhi, rcv_shipment_headers rsh
640: WHERE rhi.header_interface_id = p_header_interface_id
641: AND rsh.shipment_header_id = rhi.receipt_header_id
642: AND rhi.processing_status_code IN('RUNNING', 'PENDING')
643: AND rhi.receipt_source_code in ('VENDOR','CUSTOMER')

Line 1051: FROM rcv_headers_interface

1047: i NUMBER;
1048: l_header_id NUMBER := 0;
1049: CURSOR headers_cur_dcp(x_request_id NUMBER, x_group_id NUMBER) IS
1050: SELECT *
1051: FROM rcv_headers_interface
1052: WHERE NVL(asn_type, 'STD') IN('ASN', 'ASBN', 'STD', 'WC')
1053: AND processing_status_code IN('RUNNING', 'SUCCESS','ERROR','PENDING')
1054: AND(NVL(validation_flag, 'N') = 'Y'
1055: OR processing_status_code = 'SUCCESS') -- include success row for multi-line asn