DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on PO_LINES_ALL

Line 646: PO_LINES_ALL ORDER_LINE

642: p_type_lookup_code_tbl(i) = c_BLANKET
643: AND EXISTS
644: ( SELECT NULL
645: FROM
646: PO_LINES_ALL ORDER_LINE
647: WHERE
648: ORDER_LINE.from_header_id = p_header_id_tbl(i)
649: AND p_start_date_tbl(i) > ORDER_LINE.creation_date
650: )

Line 724: PO_LINES_ALL ORDER_LINE

720: p_type_lookup_code_tbl(i) = c_BLANKET
721: AND EXISTS
722: ( SELECT NULL
723: FROM
724: PO_LINES_ALL ORDER_LINE
725: WHERE
726: ORDER_LINE.from_header_id = p_header_id_tbl(i)
727: AND p_end_date_tbl(i) < TRUNC(ORDER_LINE.creation_date)
728: )

Line 801: PO_LINES_ALL ORDER_LINE

797: p_type_lookup_code_tbl(i) = c_CONTRACT
798: AND EXISTS
799: ( SELECT NULL
800: FROM
801: PO_LINES_ALL ORDER_LINE
802: , PO_HEADERS_ALL ORDER_HEADER
803: WHERE
804: ORDER_LINE.contract_id = p_header_id_tbl(i)
805: AND TRUNC(p_start_date_tbl(i)) > ORDER_LINE.creation_date

Line 885: PO_LINES_ALL ORDER_LINE

881: p_type_lookup_code_tbl(i) = c_CONTRACT
882: AND EXISTS
883: ( SELECT NULL
884: FROM
885: PO_LINES_ALL ORDER_LINE
886: , PO_HEADERS_ALL ORDER_HEADER
887: WHERE
888: ORDER_LINE.contract_id = p_header_id_tbl(i)
889: AND p_end_date_tbl(i) < TRUNC(ORDER_LINE.creation_date)