APPS.ICX_POR_EXT_DIAG dependencies on PO_HEADERS_ALL

Line 689: FROM po_headers_all ph,

685: INTO xContractLineId,
686: xStatus,
687: xItemNum,
688: xCategoryId
689: FROM po_headers_all ph,
690: po_lines_all pl,
691: financials_system_params_all fsp,
692: mtl_system_items_kfv mi
693: WHERE ph.segment1 = pPONum

Line 1375: xHTypeLookupCode po_headers_all.type_lookup_code%TYPE;

1371: RETURN NUMBER
1372: IS
1373: xStatus PLS_INTEGER := VALID_FOR_EXTRACT;
1374: xString VARCHAR2(2000);
1375: xHTypeLookupCode po_headers_all.type_lookup_code%TYPE;
1376: xHApprovedDate DATE;
1377: xHApprovedFlag VARCHAR2(1);
1378: xHCancelFlag VARCHAR2(1);
1379: xHFrozenFlag VARCHAR2(1);

Line 1380: xHClosedCode po_headers_all.closed_code%TYPE;

1376: xHApprovedDate DATE;
1377: xHApprovedFlag VARCHAR2(1);
1378: xHCancelFlag VARCHAR2(1);
1379: xHFrozenFlag VARCHAR2(1);
1380: xHClosedCode po_headers_all.closed_code%TYPE;
1381: xLClosedCode po_lines_all.closed_code%TYPE;
1382: xLCancelFlag VARCHAR2(1);
1383: xHStatusLookupCode po_headers_all.status_lookup_code%TYPE;
1384: xHQuotationClassCode po_headers_all.quotation_class_code%TYPE;

Line 1383: xHStatusLookupCode po_headers_all.status_lookup_code%TYPE;

1379: xHFrozenFlag VARCHAR2(1);
1380: xHClosedCode po_headers_all.closed_code%TYPE;
1381: xLClosedCode po_lines_all.closed_code%TYPE;
1382: xLCancelFlag VARCHAR2(1);
1383: xHStatusLookupCode po_headers_all.status_lookup_code%TYPE;
1384: xHQuotationClassCode po_headers_all.quotation_class_code%TYPE;
1385: xHStartDate DATE;
1386: xHEndDate DATE;
1387: xLExpirationDate DATE;

Line 1384: xHQuotationClassCode po_headers_all.quotation_class_code%TYPE;

1380: xHClosedCode po_headers_all.closed_code%TYPE;
1381: xLClosedCode po_lines_all.closed_code%TYPE;
1382: xLCancelFlag VARCHAR2(1);
1383: xHStatusLookupCode po_headers_all.status_lookup_code%TYPE;
1384: xHQuotationClassCode po_headers_all.quotation_class_code%TYPE;
1385: xHStartDate DATE;
1386: xHEndDate DATE;
1387: xLExpirationDate DATE;
1388:

Line 1395: 'ipo_headers_all ph, ' ||

1391: 'SELECT ' || VALID_FOR_EXTRACT || ' ';
1392: IF p_test_mode = 'Y' THEN
1393: xString := xString ||
1394: 'FROM ipo_line_types_b plt, ' ||
1395: 'ipo_headers_all ph, ' ||
1396: 'ipo_lines_all pl ';
1397: ELSE
1398: xString := xString ||
1399: 'FROM po_line_types_b plt, ' ||

Line 1400: 'po_headers_all ph, ' ||

1396: 'ipo_lines_all pl ';
1397: ELSE
1398: xString := xString ||
1399: 'FROM po_line_types_b plt, ' ||
1400: 'po_headers_all ph, ' ||
1401: 'po_lines_all pl ';
1402: END IF;
1403: xString := xString ||
1404: 'WHERE pl.po_line_id = :contract_line_id ' ||

Line 1462: 'ipo_headers_all ph, ' ||

1458: ' ' || VALID_FOR_EXTRACT || ')) ' ||
1459: 'FROM ';
1460: IF p_test_mode = 'Y' THEN
1461: xString := xString ||
1462: 'ipo_headers_all ph, ' ||
1463: 'ipo_lines_all pl, ' ||
1464: 'imtl_system_items_kfv mi, ' ||
1465: 'ifinancials_system_params_all fsp ';
1466: ELSE

Line 1468: 'po_headers_all ph, ' ||

1464: 'imtl_system_items_kfv mi, ' ||
1465: 'ifinancials_system_params_all fsp ';
1466: ELSE
1467: xString := xString ||
1468: 'po_headers_all ph, ' ||
1469: 'po_lines_all pl, ' ||
1470: 'mtl_system_items_kfv mi, ' ||
1471: 'financials_system_params_all fsp ';
1472: END IF;

Line 1508: 'FROM ipo_headers_all ph, ' ||

1504: 'pl.expiration_date ';
1505:
1506: IF p_test_mode = 'Y' THEN
1507: xString := xString ||
1508: 'FROM ipo_headers_all ph, ' ||
1509: 'ipo_lines_all pl ';
1510: ELSE
1511: xString := xString ||
1512: 'FROM po_headers_all ph, ' ||

Line 1512: 'FROM po_headers_all ph, ' ||

1508: 'FROM ipo_headers_all ph, ' ||
1509: 'ipo_lines_all pl ';
1510: ELSE
1511: xString := xString ||
1512: 'FROM po_headers_all ph, ' ||
1513: 'po_lines_all pl ';
1514: END IF;
1515: xString := xString ||
1516: 'WHERE ph.po_header_id = pl.po_header_id ' ||