eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_HEADERS dependencies on PO_HEADERS_ALL

Line 1318: , PO_HEADERS_ALL ORDER_HEADER

1314: AND EXISTS
1315: ( SELECT NULL
1316: FROM
1317: PO_LINES_ALL ORDER_LINE
1318: , PO_HEADERS_ALL ORDER_HEADER
1319: WHERE
1320: ORDER_LINE.from_header_id = p_header_id_tbl(i)
1321: -- Bug # 13550798 Changed logic based on approved_date
1322: --AND p_end_date_tbl(i) < TRUNC(ORDER_LINE.creation_date)

Line 1402: , PO_HEADERS_ALL ORDER_HEADER

1398: AND EXISTS
1399: ( SELECT NULL
1400: FROM
1401: PO_LINES_ALL ORDER_LINE
1402: , PO_HEADERS_ALL ORDER_HEADER
1403: WHERE
1404: ORDER_LINE.contract_id = p_header_id_tbl(i)
1405: AND TRUNC(p_start_date_tbl(i)) > ORDER_LINE.creation_date
1406: AND ORDER_HEADER.po_header_id = ORDER_LINE.po_header_id

Line 1486: , PO_HEADERS_ALL ORDER_HEADER

1482: AND EXISTS
1483: ( SELECT NULL
1484: FROM
1485: PO_LINES_ALL ORDER_LINE
1486: , PO_HEADERS_ALL ORDER_HEADER
1487: WHERE
1488: ORDER_LINE.contract_id = p_header_id_tbl(i)
1489: -- Bug # 13550798 Changed logic based on approved_date
1490: -- AND p_end_date_tbl(i) < TRUNC(ORDER_LINE.creation_date)

Line 1540: L_TEMP_SEGMENT PO_HEADERS_ALL.SEGMENT1%TYPE;

1536: l_data_key NUMBER;
1537: l_header_id_tbl PO_TBL_NUMBER;
1538: l_segment1_tbl PO_TBL_VARCHAR30;
1539: l_num_test NUMBER;
1540: L_TEMP_SEGMENT PO_HEADERS_ALL.SEGMENT1%TYPE;
1541: BEGIN
1542:
1543: IF PO_LOG.d_proc THEN
1544: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

Line 1600: We are selecting the segment1 from po_headers_all using po_header_id and segment1.

1596: BEGIN
1597: /* Bug 10233230 Start
1598: Added below logic to ensure that the document numbering validation will
1599: be fired in case of new purchase orders only.
1600: We are selecting the segment1 from po_headers_all using po_header_id and segment1.
1601: If it finds any record then we need not do the document numbering validation as it
1602: is already created and we are updating now. If there is no such record in
1603: po_headers_all then l_temp_segment value will be null and validation will be fired.
1604: */

Line 1603: po_headers_all then l_temp_segment value will be null and validation will be fired.

1599: be fired in case of new purchase orders only.
1600: We are selecting the segment1 from po_headers_all using po_header_id and segment1.
1601: If it finds any record then we need not do the document numbering validation as it
1602: is already created and we are updating now. If there is no such record in
1603: po_headers_all then l_temp_segment value will be null and validation will be fired.
1604: */
1605:
1606: BEGIN
1607: SELECT SEGMENT1 INTO L_TEMP_SEGMENT

Line 1608: FROM PO_HEADERS_ALL

1604: */
1605:
1606: BEGIN
1607: SELECT SEGMENT1 INTO L_TEMP_SEGMENT
1608: FROM PO_HEADERS_ALL
1609: WHERE
1610: SEGMENT1=l_segment1_tbl(i)
1611: AND
1612: PO_HEADER_ID=l_header_id_tbl(i);

Line 1739: FROM PO_HEADERS_ALL SAVED_HEADER

1735: AND PARAMS.user_defined_po_num_code = c_MANUAL
1736: AND p_segment1_tbl(i) IS NOT NULL
1737: AND NOT EXISTS
1738: ( SELECT NULL
1739: FROM PO_HEADERS_ALL SAVED_HEADER
1740: WHERE SAVED_HEADER.po_header_id = p_header_id_tbl(i)
1741: )
1742: ;
1743:

Line 1759: FROM PO_HEADERS_ALL HEADER

1755: (
1756: -- Check for currently existing documents.
1757: EXISTS
1758: ( SELECT NULL
1759: FROM PO_HEADERS_ALL HEADER
1760: WHERE
1761: HEADER.org_id = SES.num2
1762: AND HEADER.segment1 = SES.index_char1
1763: AND HEADER.type_lookup_code IN (c_STANDARD,c_PLANNED,c_CONTRACT,c_BLANKET)

Line 2794: FROM po_headers_all POH,

2790: SELECT 'Y' INTO is_valid_src_doc_id
2791: FROM dual
2792: WHERE EXISTS (
2793: select poh.po_header_id
2794: FROM po_headers_all POH,
2795: hr_all_organization_units_tl HOUTL,
2796: po_doc_style_lines_vl PDSL,
2797: po_document_types_all_tl PDTL,
2798: po_doc_style_headers PDSH

Line 3036: FROM po_headers_all

3032: SELECT 'Y' INTO is_valid_umbrella_prg_id
3033: FROM dual
3034: WHERE p_umbrella_program_id_tbl(i) = (
3035: SELECT Nvl(umbrella_program_id,-1)
3036: FROM po_headers_all
3037: WHERE po_header_id = p_src_doc_id_tbl(i)
3038: );
3039: EXCEPTION WHEN No_Data_Found
3040: THEN

Line 3290: FROM po_headers_all

3286: INSERT INTO po_session_gt(KEY,num1, num2)
3287: SELECT l_data_key,
3288: p_intf_header_id(i),
3289: p_style_id_tbl(i)
3290: FROM po_headers_all
3291: WHERE p_clm_source_document_id_tbl(i) IS NOT NULL
3292: AND po_header_id = p_clm_source_document_id_tbl(i)
3293: AND Nvl(style_id,-1) <> Nvl(p_style_id_tbl(i),-1);
3294:

Line 3360: FROM po_headers_all

3356: INSERT INTO po_session_gt(KEY,num1, num2)
3357: SELECT l_data_key,
3358: p_intf_header_id(i),
3359: p_vendor_id_tbl(i)
3360: FROM po_headers_all
3361: WHERE p_clm_source_document_id_tbl(i) IS NOT NULL
3362: AND p_vendor_id_tbl(i) IS NOT NULL
3363: AND po_header_id = p_clm_source_document_id_tbl(i)
3364: AND vendor_id <> p_vendor_id_tbl(i);

Line 3432: FROM po_headers_all

3428: INSERT INTO po_session_gt(KEY,num1, num2)
3429: SELECT l_data_key,
3430: p_intf_header_id(i),
3431: p_vendor_site_id_tbl(i)
3432: FROM po_headers_all
3433: WHERE p_clm_source_document_id_tbl(i) IS NOT NULL
3434: AND p_vendor_site_id_tbl(i) IS NOT NULL
3435: AND po_header_id = p_clm_source_document_id_tbl(i)
3436: AND vendor_site_id <> p_vendor_site_id_tbl(i);