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.IO_DIAGNOSTICS2 dependencies on PO_REQUISITION_HEADERS_ALL

Line 6: l_ou_id po_requisition_headers_all.org_id%TYPE := NULL;

2: /* $Header: INVDIO2B.pls 120.0.12000000.1 2007/08/09 06:48:29 ssadasiv noship $ */
3:
4: PROCEDURE receipt_shipment_sql(p_shipment_num IN VARCHAR2, p_receipt_num IN VARCHAR2, p_org_id IN NUMBER, p_sql IN OUT
5: NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
6: l_ou_id po_requisition_headers_all.org_id%TYPE := NULL;
7: l_req_num po_requisition_headers_all.segment1%TYPE := NULL;
8: l_line_num po_requisition_lines_all.line_num%TYPE := NULL;
9: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
10: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;

Line 7: l_req_num po_requisition_headers_all.segment1%TYPE := NULL;

3:
4: PROCEDURE receipt_shipment_sql(p_shipment_num IN VARCHAR2, p_receipt_num IN VARCHAR2, p_org_id IN NUMBER, p_sql IN OUT
5: NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
6: l_ou_id po_requisition_headers_all.org_id%TYPE := NULL;
7: l_req_num po_requisition_headers_all.segment1%TYPE := NULL;
8: l_line_num po_requisition_lines_all.line_num%TYPE := NULL;
9: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
10: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
11: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;

Line 16: ' FROM po_requisition_headers_all prh, ' ||

12:
13: BEGIN
14:
15: p_sql(1) := ' SELECT DISTINCT prh.* ' ||
16: ' FROM po_requisition_headers_all prh, ' ||
17: ' po_requisition_lines_all prl ' ||
18: ' WHERE prh.requisition_header_id = prl.requisition_header_id ' ||
19: ' AND prl.source_type_code = ''INVENTORY'' ' ||
20: ' AND requisition_line_id in ' ||

Line 430: ' from po_requisition_headers_all prh ,' ||

426: ' and msi.serial_number_control_code <> 1' ||
427: ' and msi.lot_control_code = 1' ||
428: ' UNION ALL' ||
429: ' select DISTINCT msnt.*' ||
430: ' from po_requisition_headers_all prh ,' ||
431: ' mtl_serial_numbers_temp msnt ,' ||
432: ' mtl_transaction_lots_temp mtlt,' ||
433: ' mtl_system_items msi,' ||
434: ' rcv_transactions_interface rti, ' ||

Line 836: ' po_requisition_headers_all prh , ' ||

832:
833: p_sql(33) := ' SELECT DISTINCT rli.* ' ||
834: ' FROM rcv_lots_interface rli , ' ||
835: ' rcv_transactions_interface rti , ' ||
836: ' po_requisition_headers_all prh , ' ||
837: ' po_requisition_lines_all prl ,' ||
838: ' rcv_shipment_headers rsh, ' ||
839: ' rcv_shipment_lines rsl ' ||
840: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 870: ' po_requisition_headers_all prh ,' ||

866: ' mtt.disable_date ' ||
867: ' from mtl_transaction_types mtt , ' ||
868: ' mtl_material_transactions mmt , ' ||
869: ' po_requisition_lines_all prl , ' ||
870: ' po_requisition_headers_all prh ,' ||
871: ' rcv_transactions rt,' ||
872: ' rcv_shipment_headers rsh, ' ||
873: ' rcv_shipment_lines rsl ' ||
874: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 892: ' po_requisition_headers_all prh,' ||

888: ' mtt.disable_date ' ||
889: ' from mtl_transaction_types mtt , ' ||
890: ' mtl_material_transactions mmt , ' ||
891: ' po_requisition_lines_all prl , ' ||
892: ' po_requisition_headers_all prh,' ||
893: ' oe_order_lines_all sol,' ||
894: ' rcv_shipment_headers rsh, ' ||
895: ' rcv_shipment_lines rsl ' ||
896: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1038: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;

1034:
1035:
1036: PROCEDURE req_line_receipt_shipment_sql(p_ou_id IN NUMBER, p_req_num IN VARCHAR2, p_line_num IN NUMBER, p_shipment_num
1037: IN VARCHAR2, p_receipt_num IN VARCHAR2, p_org_id IN NUMBER, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
1038: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
1039: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
1040: l_line_num po_requisition_lines_all.line_num%TYPE := Nvl(p_line_num,-99);
1041: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
1042: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;

Line 1039: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;

1035:
1036: PROCEDURE req_line_receipt_shipment_sql(p_ou_id IN NUMBER, p_req_num IN VARCHAR2, p_line_num IN NUMBER, p_shipment_num
1037: IN VARCHAR2, p_receipt_num IN VARCHAR2, p_org_id IN NUMBER, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
1038: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
1039: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
1040: l_line_num po_requisition_lines_all.line_num%TYPE := Nvl(p_line_num,-99);
1041: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := p_shipment_num;
1042: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
1043: l_org_id rcv_shipment_headers.ship_to_org_id%TYPE := p_org_id;

Line 1053: ' FROM po_requisition_headers_all prh, ' ||

1049:
1050:
1051:
1052: p_sql(1) := ' SELECT prh.* ' ||
1053: ' FROM po_requisition_headers_all prh, ' ||
1054: ' po_requisition_lines_all prl ' ||
1055: ' where prh.segment1 = ' || '''' || l_req_num || '''' ||
1056: ' and prh.org_id = ' || l_ou_id ||
1057: ' AND prl.requisition_header_id = prh.requisition_header_id ' ||

Line 1066: ' FROM po_requisition_headers_all prh, ' ||

1062:
1063:
1064:
1065: p_sql(2) := ' SELECT prl.* ' ||
1066: ' FROM po_requisition_headers_all prh, ' ||
1067: ' po_requisition_lines_all prl, ' ||
1068: ' rcv_shipment_headers rsh, ' ||
1069: ' rcv_shipment_lines rsl ' ||
1070: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1087: ' FROM po_requisition_headers_all prh, ' ||

1083:
1084:
1085:
1086: p_sql(3) := ' SELECT prd.* ' ||
1087: ' FROM po_requisition_headers_all prh, ' ||
1088: ' po_requisition_lines_all prl, ' ||
1089: ' po_req_distributions_all prd, ' ||
1090: ' rcv_shipment_headers rsh, ' ||
1091: ' rcv_shipment_lines rsl ' ||

Line 1110: ' po_requisition_headers_all prh,' ||

1106:
1107: p_sql(4) := ' SELECT oel.* ' ||
1108: ' FROM oe_order_lines_all oel, ' ||
1109: ' po_requisition_lines_all prl, ' ||
1110: ' po_requisition_headers_all prh,' ||
1111: ' rcv_shipment_headers rsh, ' ||
1112: ' rcv_shipment_lines rsl ' ||
1113: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1114: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 1132: ' po_requisition_headers_all prh , ' ||

1128: ' wsh_delivery_assignments wda , ' ||
1129: ' wsh_new_deliveries wnd , ' ||
1130: ' oe_order_lines_all sol , ' ||
1131: ' po_requisition_lines_all prl , ' ||
1132: ' po_requisition_headers_all prh , ' ||
1133: ' rcv_shipment_headers rsh, ' ||
1134: ' rcv_shipment_lines rsl ' ||
1135: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1136: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 1153: ' po_requisition_headers_all prh , ' ||

1149: ' SELECT wsh.* ' ||
1150: ' FROM wsh_delivery_details wsh , ' ||
1151: ' mtl_transactions_interface mti , ' ||
1152: ' po_requisition_lines_all prl , ' ||
1153: ' po_requisition_headers_all prh , ' ||
1154: ' oe_order_lines_all sol, ' ||
1155: ' rcv_shipment_headers rsh, ' ||
1156: ' rcv_shipment_lines rsl ' ||
1157: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1201: ' po_requisition_headers_all prh , ' ||

1197:
1198: p_sql(9) := ' SELECT DISTINCT rsh.* ' ||
1199: ' FROM rcv_shipment_headers rsh , ' ||
1200: ' rcv_shipment_lines rsl , ' ||
1201: ' po_requisition_headers_all prh , ' ||
1202: ' po_requisition_lines_all prl ' ||
1203: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1204: ' and rsh.ship_to_org_id = ' || l_org_id ||
1205: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1219: ' po_requisition_headers_all prh , ' ||

1215:
1216: p_sql(10) := ' SELECT rsl.* ' ||
1217: ' FROM rcv_shipment_headers rsh, ' ||
1218: ' rcv_shipment_lines rsl , ' ||
1219: ' po_requisition_headers_all prh , ' ||
1220: ' po_requisition_lines_all prl ' ||
1221: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1222: ' and rsh.ship_to_org_id = ' || l_org_id ||
1223: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1234: ' po_requisition_headers_all prh , ' ||

1230: ' AND rsl.source_document_code = ''REQ'' ';
1231:
1232: p_sql(11) := ' SELECT rt.* ' ||
1233: ' FROM rcv_transactions rt , ' ||
1234: ' po_requisition_headers_all prh , ' ||
1235: ' po_requisition_lines_all prl ,' ||
1236: ' rcv_shipment_headers rsh, ' ||
1237: ' rcv_shipment_lines rsl ' ||
1238: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1252: ' po_requisition_headers_all prh , ' ||

1248: ' AND rt.shipment_line_id = rsl.shipment_line_id ';
1249:
1250: p_sql(12) := ' SELECT ms.* ' ||
1251: ' FROM mtl_supply ms , ' ||
1252: ' po_requisition_headers_all prh , ' ||
1253: ' po_requisition_lines_all prl ,' ||
1254: ' rcv_shipment_headers rsh, ' ||
1255: ' rcv_shipment_lines rsl ' ||
1256: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1274: ' po_requisition_headers_all prh ,' ||

1270:
1271:
1272: p_sql(13) := ' SELECT rs.* ' ||
1273: ' FROM rcv_supply rs , ' ||
1274: ' po_requisition_headers_all prh ,' ||
1275: ' po_requisition_lines_all prl,' ||
1276: ' rcv_shipment_headers rsh, ' ||
1277: ' rcv_shipment_lines rsl ' ||
1278: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1293: ' po_requisition_headers_all prh, ' ||

1289: p_sql(14) := ' SELECT mtrl.* ' ||
1290: ' FROM mtl_txn_request_lines mtrl, ' ||
1291: ' rcv_shipment_headers rsh, ' ||
1292: ' rcv_shipment_lines rsl, ' ||
1293: ' po_requisition_headers_all prh, ' ||
1294: ' po_requisition_lines_all prl ' ||
1295: ' WHERE rsh.shipment_num = '|| '''' || l_shipment_num || '''' ||
1296: ' and rsh.ship_to_org_id = '|| l_org_id ||
1297: ' and prh.segment1 = '|| '''' || l_req_num || '''' ||

Line 1314: ' po_requisition_headers_all prh, ' ||

1310: /*' SELECT mtrl.* ' ||
1311: ' FROM mtl_txn_request_lines mtrl, ' ||
1312: ' rcv_shipment_headers rsh, ' ||
1313: ' rcv_shipment_lines rsl, ' ||
1314: ' po_requisition_headers_all prh, ' ||
1315: ' po_requisition_lines_all prl ' ||
1316: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1317: ' and rsh.ship_to_org_id = ' || l_org_id ||
1318: ' and prh.segment1 = ' || '''' || l_req_num || '''' ||

Line 1332: ' PO_REQUISITION_HEADERS_ALL PRH, ' ||

1328:
1329: p_sql(15) := ' SELECT MTI.* ' ||
1330: ' FROM MTL_TRANSACTIONS_INTERFACE MTI, ' ||
1331: ' PO_REQUISITION_LINES_ALL PRL, ' ||
1332: ' PO_REQUISITION_HEADERS_ALL PRH, ' ||
1333: ' OE_ORDER_LINES_ALL SOL, ' ||
1334: ' RCV_SHIPMENT_HEADERS RSH, ' ||
1335: ' RCV_SHIPMENT_LINES RSL ' ||
1336: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1353: ' po_requisition_headers_all prh, ' ||

1349:
1350: p_sql(16) := ' SELECT mmtt.* ' ||
1351: ' FROM mtl_material_transactions_temp mmtt , ' ||
1352: ' po_requisition_lines_all prl , ' ||
1353: ' po_requisition_headers_all prh, ' ||
1354: ' rcv_shipment_headers rsh, ' ||
1355: ' rcv_shipment_lines rsl,' ||
1356: ' rcv_transactions rt ' ||
1357: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1375: ' po_requisition_headers_all prh, ' ||

1371: ' UNION ALL' ||
1372: ' SELECT mmtt.* ' ||
1373: ' FROM mtl_material_transactions_temp mmtt , ' ||
1374: ' po_requisition_lines_all prl , ' ||
1375: ' po_requisition_headers_all prh, ' ||
1376: ' rcv_shipment_headers rsh, ' ||
1377: ' rcv_shipment_lines rsl,' ||
1378: ' oe_order_lines_all sol ' ||
1379: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1399: ' po_requisition_headers_all prh, ' ||

1395:
1396: p_sql(17) := ' SELECT mmt.* ' ||
1397: ' FROM mtl_material_transactions mmt , ' ||
1398: ' po_requisition_lines_all prl , ' ||
1399: ' po_requisition_headers_all prh, ' ||
1400: ' rcv_shipment_headers rsh, ' ||
1401: ' rcv_shipment_lines rsl,' ||
1402: ' rcv_transactions rt ' ||
1403: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1420: ' po_requisition_headers_all prh, ' ||

1416: ' UNION ALL' ||
1417: ' SELECT mmt.* ' ||
1418: ' FROM mtl_material_transactions mmt , ' ||
1419: ' po_requisition_lines_all prl , ' ||
1420: ' po_requisition_headers_all prh, ' ||
1421: ' rcv_shipment_headers rsh, ' ||
1422: ' rcv_shipment_lines rsl,' ||
1423: ' oe_order_lines_all sol ' ||
1424: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1444: ' po_requisition_headers_all prh, ' ||

1440: p_sql(18) := ' SELECT mr.* ' ||
1441: ' FROM mtl_reservations mr , ' ||
1442: ' oe_order_lines_all sol , ' ||
1443: ' po_requisition_lines_all prl , ' ||
1444: ' po_requisition_headers_all prh, ' ||
1445: ' rcv_shipment_headers rsh, ' ||
1446: ' rcv_shipment_lines rsl ' ||
1447: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1448: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 1464: ' po_requisition_headers_all prh , ' ||

1460: ' SELECT mr.* ' ||
1461: ' FROM mtl_reservations mr , ' ||
1462: ' mtl_transactions_interface mti , ' ||
1463: ' po_requisition_lines_all prl , ' ||
1464: ' po_requisition_headers_all prh , ' ||
1465: ' oe_order_lines_all sol ,' ||
1466: ' rcv_shipment_headers rsh, ' ||
1467: ' rcv_shipment_lines rsl ' ||
1468: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1485: ' po_requisition_headers_all prh , ' ||

1481: p_sql(19) := ' SELECT md.* ' ||
1482: ' FROM mtl_demand md , ' ||
1483: ' oe_order_lines_all sol , ' ||
1484: ' po_requisition_lines_all prl , ' ||
1485: ' po_requisition_headers_all prh , ' ||
1486: ' rcv_shipment_headers rsh, ' ||
1487: ' rcv_shipment_lines rsl ' ||
1488: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1489: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 1506: ' po_requisition_headers_all prh , ' ||

1502: ' SELECT md.* ' ||
1503: ' FROM mtl_demand md , ' ||
1504: ' mtl_transactions_interface mti , ' ||
1505: ' po_requisition_lines_all prl , ' ||
1506: ' po_requisition_headers_all prh , ' ||
1507: ' oe_order_lines_all sol , ' ||
1508: ' rcv_shipment_headers rsh, ' ||
1509: ' rcv_shipment_lines rsl ' ||
1510: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1533: ' po_requisition_headers_all prh ,' ||

1529: p_sql(20) := ' select distinct msn.* ' ||
1530: ' from mtl_serial_numbers msn , ' ||
1531: ' mtl_material_transactions mmt , ' ||
1532: ' po_requisition_lines_all prl , ' ||
1533: ' po_requisition_headers_all prh ,' ||
1534: ' rcv_shipment_headers rsh, ' ||
1535: ' rcv_shipment_lines rsl ,' ||
1536: ' rcv_transactions rt' ||
1537: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1554: ' po_requisition_headers_all prh ,' ||

1550: ' select distinct msn.* ' ||
1551: ' from mtl_serial_numbers msn , ' ||
1552: ' mtl_material_transactions mmt , ' ||
1553: ' po_requisition_lines_all prl , ' ||
1554: ' po_requisition_headers_all prh ,' ||
1555: ' oe_order_lines_all sol,' ||
1556: ' rcv_shipment_headers rsh, ' ||
1557: ' rcv_shipment_lines rsl ' ||
1558: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 1576: ' po_requisition_headers_all prh ,' ||

1572:
1573:
1574: p_sql(21) := ' select DISTINCT msnt.*' ||
1575: ' from po_requisition_lines_all prl ,' ||
1576: ' po_requisition_headers_all prh ,' ||
1577: ' mtl_serial_numbers_temp msnt ,' ||
1578: ' mtl_system_items msi,' ||
1579: ' rcv_transactions_interface rti,' ||
1580: ' rcv_shipment_headers rsh, ' ||

Line 1602: ' po_requisition_headers_all prh ,' ||

1598: ' and msi.lot_control_code = 1' ||
1599: ' UNION ALL' ||
1600: ' select DISTINCT msnt.*' ||
1601: ' from po_requisition_lines_all prl ,' ||
1602: ' po_requisition_headers_all prh ,' ||
1603: ' mtl_serial_numbers_temp msnt ,' ||
1604: ' mtl_transaction_lots_temp mtlt,' ||
1605: ' mtl_system_items msi,' ||
1606: ' rcv_transactions_interface rti,' ||

Line 1630: ' po_requisition_headers_all prh,' ||

1626: ' and msi.lot_control_code <> 1' ||
1627: ' UNION ALL' ||
1628: ' select DISTINCT msnt.*' ||
1629: ' from po_requisition_lines_all prl,' ||
1630: ' po_requisition_headers_all prh,' ||
1631: ' mtl_serial_numbers_temp msnt,' ||
1632: ' mtl_system_items msi,' ||
1633: ' oe_order_lines_all sol,' ||
1634: ' mtl_material_transactions_temp mmtt,' ||

Line 1657: ' po_requisition_headers_all prh,' ||

1653: ' and msi.lot_control_code = 1' ||
1654: ' UNION ALL' ||
1655: ' select DISTINCT msnt.*' ||
1656: ' from po_requisition_lines_all prl,' ||
1657: ' po_requisition_headers_all prh,' ||
1658: ' mtl_serial_numbers_temp msnt,' ||
1659: ' mtl_transaction_lots_temp mtlt,' ||
1660: ' mtl_system_items msi,' ||
1661: ' oe_order_lines_all sol,' ||

Line 1689: ' po_requisition_headers_all prh , ' ||

1685:
1686: p_sql(22) := ' select distinct msni.* ' ||
1687: ' from rcv_transactions_interface rti ,' ||
1688: ' po_requisition_lines_all prl , ' ||
1689: ' po_requisition_headers_all prh , ' ||
1690: ' mtl_serial_numbers_interface msni ,' ||
1691: ' mtl_system_items msi,' ||
1692: ' rcv_shipment_headers rsh, ' ||
1693: ' rcv_shipment_lines rsl ' ||

Line 1715: ' po_requisition_headers_all prh , ' ||

1711: ' UNION ALL' ||
1712: ' select distinct msni.* ' ||
1713: ' from rcv_transactions_interface rti ,' ||
1714: ' po_requisition_lines_all prl , ' ||
1715: ' po_requisition_headers_all prh , ' ||
1716: ' mtl_serial_numbers_interface msni ,' ||
1717: ' mtl_transaction_lots_interface mtli,' ||
1718: ' mtl_system_items msi,' ||
1719: ' rcv_shipment_headers rsh, ' ||

Line 1843: ' po_requisition_headers_all prh , ' ||

1839:
1840: p_sql(24) := ' SELECT rss.* ' ||
1841: ' FROM rcv_serials_supply rss , ' ||
1842: ' rcv_shipment_lines rsl , ' ||
1843: ' po_requisition_headers_all prh , ' ||
1844: ' po_requisition_lines_all prl , ' ||
1845: ' rcv_shipment_headers rsh ' ||
1846: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1847: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 1863: ' po_requisition_headers_all prh , ' ||

1859:
1860: p_sql(25) := ' SELECT rst.* ' ||
1861: ' FROM rcv_serial_transactions rst , ' ||
1862: ' rcv_shipment_lines rsl , ' ||
1863: ' po_requisition_headers_all prh , ' ||
1864: ' po_requisition_lines_all prl , ' ||
1865: ' rcv_shipment_headers rsh ' ||
1866: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
1867: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 1883: ' po_requisition_headers_all prh , ' ||

1879:
1880: p_sql(26) := ' SELECT rsi.* ' ||
1881: ' FROM rcv_serials_interface rsi , ' ||
1882: ' rcv_shipment_lines rsl , ' ||
1883: ' po_requisition_headers_all prh , ' ||
1884: ' po_requisition_lines_all prl , ' ||
1885: ' rcv_shipment_headers rsh ,' ||
1886: ' rcv_transactions_interface rti' ||
1887: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 2059: ' po_requisition_headers_all prh , ' ||

2055:
2056: p_sql(31) := ' SELECT rls.* ' ||
2057: ' FROM rcv_lots_supply rls , ' ||
2058: ' rcv_shipment_lines rsl , ' ||
2059: ' po_requisition_headers_all prh , ' ||
2060: ' po_requisition_lines_all prl , ' ||
2061: ' oe_order_lines_all sol , ' ||
2062: ' rcv_shipment_headers rsh ' ||
2063: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 2083: ' po_requisition_headers_all prh , ' ||

2079:
2080: p_sql(32) := ' SELECT rlt.* ' ||
2081: ' FROM rcv_lot_transactions rlt , ' ||
2082: ' rcv_shipment_lines rsl , ' ||
2083: ' po_requisition_headers_all prh , ' ||
2084: ' po_requisition_lines_all prl , ' ||
2085: ' rcv_shipment_headers rsh ' ||
2086: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||
2087: ' and rsh.ship_to_org_id = ' || l_org_id ||

Line 2103: ' po_requisition_headers_all prh , ' ||

2099:
2100: p_sql(33) := ' SELECT rli.* ' ||
2101: ' FROM rcv_lots_interface rli , ' ||
2102: ' rcv_transactions_interface rti , ' ||
2103: ' po_requisition_headers_all prh , ' ||
2104: ' po_requisition_lines_all prl ,' ||
2105: ' rcv_shipment_headers rsh,' ||
2106: ' rcv_shipment_lines rsl' ||
2107: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 2123: ' FROM po_requisition_headers_all prh, ' ||

2119:
2120:
2121:
2122: p_sql(34) := ' SELECT DISTINCT msi.* ' ||
2123: ' FROM po_requisition_headers_all prh, ' ||
2124: ' po_requisition_lines_all prl, ' ||
2125: ' mtl_system_items msi, ' ||
2126: ' rcv_shipment_headers rsh, ' ||
2127: ' rcv_shipment_lines rsl ' ||

Line 2150: ' po_requisition_headers_all prh ,' ||

2146: ' mtt.disable_date ' ||
2147: ' from mtl_transaction_types mtt , ' ||
2148: ' mtl_material_transactions mmt , ' ||
2149: ' po_requisition_lines_all prl , ' ||
2150: ' po_requisition_headers_all prh ,' ||
2151: ' rcv_transactions rt,' ||
2152: ' rcv_shipment_headers rsh, ' ||
2153: ' rcv_shipment_lines rsl ' ||
2154: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 2174: ' po_requisition_headers_all prh,' ||

2170: ' mtt.disable_date ' ||
2171: ' from mtl_transaction_types mtt , ' ||
2172: ' mtl_material_transactions mmt , ' ||
2173: ' po_requisition_lines_all prl , ' ||
2174: ' po_requisition_headers_all prh,' ||
2175: ' oe_order_lines_all sol,' ||
2176: ' rcv_shipment_headers rsh, ' ||
2177: ' rcv_shipment_lines rsl ' ||
2178: ' WHERE rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 2197: ' FROM po_requisition_headers_all prh , ' ||

2193: p_sql(36) := ' SELECT ood.* ' ||
2194: ' FROM org_organization_definitions ood ' ||
2195: ' WHERE exists ' ||
2196: ' (SELECT 1 ' ||
2197: ' FROM po_requisition_headers_all prh , ' ||
2198: ' po_requisition_lines_all prl , ' ||
2199: ' financials_system_params_all fsp , ' ||
2200: ' rcv_shipment_headers rsh, ' ||
2201: ' rcv_shipment_lines rsl ' ||

Line 2220: ' po_requisition_headers_all prh , ' ||

2216:
2217:
2218: p_sql(37) := ' SELECT DISTINCT mp.* ' ||
2219: ' FROM mtl_parameters mp , ' ||
2220: ' po_requisition_headers_all prh , ' ||
2221: ' po_requisition_lines_all prl ,' ||
2222: ' rcv_shipment_headers rsh, ' ||
2223: ' rcv_shipment_lines rsl ' ||
2224: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 2241: ' FROM po_requisition_headers_all prh , ' ||

2237: p_sql(38) := ' SELECT miop.* ' ||
2238: ' FROM mtl_interorg_parameters miop ' ||
2239: ' WHERE exists ' ||
2240: ' (SELECT 1 ' ||
2241: ' FROM po_requisition_headers_all prh , ' ||
2242: ' po_requisition_lines_all prl, ' ||
2243: ' rcv_shipment_headers rsh, ' ||
2244: ' rcv_shipment_lines rsl ' ||
2245: ' where rsh.shipment_num = ' || '''' || l_shipment_num || '''' ||

Line 2263: ' FROM po_requisition_headers_all prh , ' ||

2259: p_sql(39) := ' SELECT rp.* ' ||
2260: ' FROM rcv_parameters rp ' ||
2261: ' WHERE exists ' ||
2262: ' (SELECT 1 ' ||
2263: ' FROM po_requisition_headers_all prh , ' ||
2264: ' po_requisition_lines_all prl , ' ||
2265: ' financials_system_params_all fsp, ' ||
2266: ' rcv_shipment_headers rsh, ' ||
2267: ' rcv_shipment_lines rsl ' ||