DBA Data[Home] [Help]

APPS.ICX_POR_EXT_DIAG dependencies on PO_LINES_ALL

Line 690: po_lines_all pl,

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
694: AND (ph.org_id is null and pOperatingUnitId is null or ph.org_id = pOperatingUnitId)

Line 1381: xLClosedCode po_lines_all.closed_code%TYPE;

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;
1385: xHStartDate DATE;

Line 1396: 'ipo_lines_all pl ';

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, ' ||
1400: 'po_headers_all ph, ' ||

Line 1401: 'po_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 ' ||
1405: 'AND ph.po_header_id = pl.po_header_id ' ||

Line 1463: 'ipo_lines_all pl, ' ||

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
1467: xString := xString ||

Line 1469: 'po_lines_all pl, ' ||

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;
1473: xString := xString ||

Line 1509: 'ipo_lines_all pl ';

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, ' ||
1513: 'po_lines_all pl ';

Line 1513: 'po_lines_all pl ';

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 ' ||
1517: 'AND pl.po_line_id = :contract_line_id';