DBA Data[Home] [Help]

APPS.RCV_DCP_PVT dependencies on RCV_HEADERS_INTERFACE

Line 667: FROM rcv_headers_interface rhi, rcv_shipment_headers rsh

663: , rhi.receipt_source_code
664: , rhi.asn_type rhi_asn_type
665: , rsh.asn_type rsh_asn_type
666: , rhi.creation_date
667: FROM rcv_headers_interface rhi, rcv_shipment_headers rsh
668: WHERE rhi.header_interface_id = p_header_interface_id
669: AND rsh.shipment_header_id = rhi.receipt_header_id
670: AND rhi.processing_status_code IN('RUNNING', 'PENDING')
671: AND rhi.receipt_source_code in ('VENDOR','CUSTOMER')

Line 1079: FROM rcv_headers_interface

1075: i NUMBER;
1076: l_header_id NUMBER := 0;
1077: CURSOR headers_cur_dcp(x_request_id NUMBER, x_group_id NUMBER) IS
1078: SELECT *
1079: FROM rcv_headers_interface
1080: WHERE NVL(asn_type, 'STD') IN('ASN', 'ASBN', 'STD', 'WC')
1081: AND processing_status_code IN('RUNNING', 'SUCCESS','ERROR','PENDING')
1082: AND(NVL(validation_flag, 'N') = 'Y'
1083: OR processing_status_code = 'SUCCESS') -- include success row for multi-line asn