APPS.PO_VAL_HEADERS dependencies on PO_HEADERS_ALL

Line 802: , PO_HEADERS_ALL ORDER_HEADER

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
806: AND ORDER_HEADER.po_header_id = ORDER_LINE.po_header_id

Line 886: , PO_HEADERS_ALL ORDER_HEADER

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)
890: AND ORDER_HEADER.po_header_id = ORDER_LINE.po_header_id

Line 1106: FROM PO_HEADERS_ALL SAVED_HEADER

1102: AND PARAMS.user_defined_po_num_code = c_MANUAL
1103: AND p_segment1_tbl(i) IS NOT NULL
1104: AND NOT EXISTS
1105: ( SELECT NULL
1106: FROM PO_HEADERS_ALL SAVED_HEADER
1107: WHERE SAVED_HEADER.po_header_id = p_header_id_tbl(i)
1108: )
1109: ;
1110:

Line 1126: FROM PO_HEADERS_ALL HEADER

1122: (
1123: -- Check for currently existing documents.
1124: EXISTS
1125: ( SELECT NULL
1126: FROM PO_HEADERS_ALL HEADER
1127: WHERE
1128: HEADER.org_id = SES.num2
1129: AND HEADER.segment1 = SES.index_char1
1130: AND HEADER.type_lookup_code IN (c_STANDARD,c_PLANNED,c_CONTRACT,c_BLANKET)