APPS.POS_WC_CREATE_UPDATE_PVT dependencies on RCV_HEADERS_INTERFACE

Line 75: FROM RCV_HEADERS_INTERFACE RHI,

71:
72: l_draft_exists := 'N';
73:
74: SELECT 'Y' INTO l_draft_exists
75: FROM RCV_HEADERS_INTERFACE RHI,
76: RCV_TRANSACTIONS_INTERFACE RTI
77: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
78: RTI.PO_HEADER_ID = p_po_header_id AND
79: RHI.processing_status_code = 'DRAFT' AND

Line 315: RCV_HEADERS_INTERFACE RHI,

311:
312: SELECT SUM(NVL(RTI.AMOUNT, Round(RTI.QUANTITY*POLL.PRICE_OVERRIDE,POS_WC_VIEW_CANCEL_PVT.get_currency_precision(poll.po_header_id))))
313: INTO l_intf_request
314: FROM RCV_TRANSACTIONS_INTERFACE RTI,
315: RCV_HEADERS_INTERFACE RHI,
316: PO_LINE_LOCATIONS_ALL POLL
317: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID and
318: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
319: RHI.HEADER_INTERFACE_ID = p_wc_id;

Line 490: FROM RCV_HEADERS_INTERFACE RHI,

486: IF (p_wc_stage = 'INTERFACE') THEN
487:
488: SELECT RHI.request_date, RHI.processing_status_code, RHI.transaction_type
489: INTO l_request_date, l_header_processing_status, l_header_transaction_type
490: FROM RCV_HEADERS_INTERFACE RHI,
491: RCV_TRANSACTIONS_INTERFACE RTI
492: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
493: RTI.INTERFACE_TRANSACTION_ID = p_wc_pay_item_id;
494:

Line 528: RCV_HEADERS_INTERFACE RHI

524: SELECT sum(NVL(RTI.AMOUNT,RTI.QUANTITY))
525: INTO l_wc_prev_submitted_intf
526: FROM PO_LINE_LOCATIONS_ALL POLL,
527: RCV_TRANSACTIONS_INTERFACE RTI,
528: RCV_HEADERS_INTERFACE RHI
529: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
530: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
531: RTI.PROCESSING_STATUS_CODE = 'PENDING' AND
532: RTI.TRANSACTION_STATUS_CODE = 'PENDING' AND