DBA Data[Home] [Help]

APPS.PO_PRICE_HELPER dependencies on PO_LINE_LOCATIONS

Line 725: , PO_LINE_LOCATIONS_ALL POLL

721: WHERE EXISTS
722: (SELECT null
723: FROM
724: RCV_TRANSACTIONS_INTERFACE RTI
725: , PO_LINE_LOCATIONS_ALL POLL
726: WHERE
727: RTI.po_line_location_id = POLL.line_location_id
728: AND POLL.po_line_id = p_line_id_tbl(i)
729: AND RTI.transaction_status_code = c_PENDING

Line 1006: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;

1002:
1003: l_doc_sub_type VARCHAR2(30);
1004: l_source_document_type PO_HEADERS.type_lookup_code%TYPE;
1005: l_source_document_header_id PO_LINES.po_header_id%TYPE;
1006: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;
1007: l_rate PO_HEADERS.rate%TYPE;
1008: l_rate_type PO_HEADERS.rate_type%TYPE;
1009:
1010: l_return_status VARCHAR2(1);