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.INV_DIAG_RCV_IPROC_COMMON dependencies on RCV_SHIPMENT_HEADERS

Line 323: ' rcv_shipment_headers rsh, ' ||

319: ' and prh.org_id = '||l_operating_id;
320:
321: p_sql(14) := ' SELECT DISTINCT rsh.* ' ||
322: ' from rcv_shipment_lines rsl , ' ||
323: ' rcv_shipment_headers rsh, ' ||
324: ' po_line_locations_all pll , ' ||
325: ' po_distributions_all pd,' ||
326: ' po_req_distributions_all prd ,' ||
327: ' po_requisition_lines_all prl ,' ||

Line 343: ' rcv_shipment_headers rsh, ' ||

339: ' and prh.org_id = '||l_operating_id;
340:
341: p_sql(15) := ' SELECT DISTINCT rsl.* ' ||
342: ' from rcv_shipment_lines rsl , ' ||
343: ' rcv_shipment_headers rsh, ' ||
344: ' po_line_locations_all pll , ' ||
345: ' po_distributions_all pd,' ||
346: ' po_req_distributions_all prd ,' ||
347: ' po_requisition_lines_all prl ,' ||

Line 363: ' rcv_shipment_headers rsh, ' ||

359: ' and prh.org_id = '||l_operating_id;
360:
361: p_sql(16) := ' SELECT DISTINCT rt.* ' ||
362: ' from rcv_transactions rt , ' ||
363: ' rcv_shipment_headers rsh, ' ||
364: ' po_line_locations_all pll , ' ||
365: ' po_distributions_all pd,' ||
366: ' po_req_distributions_all prd ,' ||
367: ' po_requisition_lines_all prl ,' ||

Line 423: ' rcv_shipment_headers rsh, ' ||

419: ' from rcv_headers_interface rhi ' ||
420: ' WHERE exists ' ||
421: ' (SELECT 1 ' ||
422: ' from rcv_shipment_lines rsl , ' ||
423: ' rcv_shipment_headers rsh, ' ||
424: ' po_line_locations_all pll , ' ||
425: ' po_distributions_all pd,' ||
426: ' po_req_distributions_all prd ,' ||
427: ' po_requisition_lines_all prl ,' ||

Line 808: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||

804: ' po_distributions_all pd,' ||
805: ' po_req_distributions_all prd ,' ||
806: ' po_requisition_lines_all prl ,' ||
807: ' po_requisition_headers_all prh,' ||
808: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
809: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
810: ' and prh.requisition_header_id = prl.requisition_header_id' ||
811: ' and prl.requisition_line_id = prd.requisition_line_id' ||
812: ' and prl.source_type_code = ''VENDOR''' ||

Line 843: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||

839: ' po_distributions_all pd,' ||
840: ' po_req_distributions_all prd ,' ||
841: ' po_requisition_lines_all prl ,' ||
842: ' po_requisition_headers_all prh, ' ||
843: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
844: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
845: ' and prh.requisition_header_id = prl.requisition_header_id' ||
846: ' and prl.requisition_line_id = prd.requisition_line_id' ||
847: ' and prl.source_type_code = ''VENDOR''' ||

Line 961: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||

957: ' po_distributions_all pd,' ||
958: ' po_req_distributions_all prd ,' ||
959: ' po_requisition_lines_all prl ,' ||
960: ' po_requisition_headers_all prh, ' ||
961: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
962: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
963: ' and prh.requisition_header_id = prl.requisition_header_id' ||
964: ' and prl.requisition_line_id = prd.requisition_line_id' ||
965: ' and prl.source_type_code = ''VENDOR''' ||

Line 992: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||

988: ' po_distributions_all pd,' ||
989: ' po_req_distributions_all prd ,' ||
990: ' po_requisition_lines_all prl ,' ||
991: ' po_requisition_headers_all prh, ' ||
992: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
993: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
994: ' and prh.requisition_header_id = prl.requisition_header_id' ||
995: ' and prl.requisition_line_id = prd.requisition_line_id' ||
996: ' and prl.source_type_code = ''VENDOR''' ||

Line 1023: ' rcv_shipment_headers rsh ' ||

1019: ' po_distributions_all pd,' ||
1020: ' po_req_distributions_all prd ,' ||
1021: ' po_requisition_lines_all prl ,' ||
1022: ' po_requisition_headers_all prh, ' ||
1023: ' rcv_shipment_headers rsh ' ||
1024: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1025: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1026: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1027: ' and prl.source_type_code = ''VENDOR''' ||

Line 1050: ' rcv_shipment_headers rsh ' ||

1046: ' po_distributions_all pd,' ||
1047: ' po_req_distributions_all prd ,' ||
1048: ' po_requisition_lines_all prl ,' ||
1049: ' po_requisition_headers_all prh, ' ||
1050: ' rcv_shipment_headers rsh ' ||
1051: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1052: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1053: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1054: ' and prl.source_type_code = ''VENDOR''' ||

Line 1080: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||

1076: ' po_distributions_all pd,' ||
1077: ' po_req_distributions_all prd ,' ||
1078: ' po_requisition_lines_all prl ,' ||
1079: ' po_requisition_headers_all prh, ' ||
1080: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||
1081: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1082: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1083: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1084: ' and prl.source_type_code = ''VENDOR''' ||

Line 1111: ' rcv_shipment_headers rsh, rcv_transactions rt' ||

1107: ' po_distributions_all pd,' ||
1108: ' po_req_distributions_all prd ,' ||
1109: ' po_requisition_lines_all prl ,' ||
1110: ' po_requisition_headers_all prh, ' ||
1111: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
1112: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1113: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1114: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1115: ' and prl.source_type_code = ''VENDOR''' ||

Line 1145: ' rcv_shipment_headers rsh, rcv_transactions rt' ||

1141: ' po_distributions_all pd,' ||
1142: ' po_req_distributions_all prd ,' ||
1143: ' po_requisition_lines_all prl ,' ||
1144: ' po_requisition_headers_all prh, ' ||
1145: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
1146: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1147: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1148: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1149: ' and prl.source_type_code = ''VENDOR''' ||

Line 1205: ' rcv_shipment_headers rsh, rcv_transactions rt' ||

1201: ' po_distributions_all pd,' ||
1202: ' po_req_distributions_all prd ,' ||
1203: ' po_requisition_lines_all prl ,' ||
1204: ' po_requisition_headers_all prh, ' ||
1205: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
1206: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1207: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1208: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1209: ' and prl.source_type_code = ''VENDOR''' ||

Line 1235: ' rcv_shipment_headers rsh ' ||

1231: ' po_distributions_all pd,' ||
1232: ' po_req_distributions_all prd ,' ||
1233: ' po_requisition_lines_all prl ,' ||
1234: ' po_requisition_headers_all prh, ' ||
1235: ' rcv_shipment_headers rsh ' ||
1236: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1237: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1238: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1239: ' and prl.source_type_code = ''VENDOR''' ||

Line 1264: ' rcv_shipment_headers rsh ' ||

1260: ' po_distributions_all pd,' ||
1261: ' po_req_distributions_all prd ,' ||
1262: ' po_requisition_lines_all prl ,' ||
1263: ' po_requisition_headers_all prh, ' ||
1264: ' rcv_shipment_headers rsh ' ||
1265: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1266: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1267: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1268: ' and prl.source_type_code = ''VENDOR''' ||

Line 1321: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;

1317: -------------------------------------------------------
1318: PROCEDURE build_req_rcv_sql(p_receipt_num IN VARCHAR2,p_org_id IN NUMBER,p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
1319:
1320: -- Initialize Local Variables.
1321: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
1322: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;
1323:
1324: BEGIN
1325:

Line 1322: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;

1318: PROCEDURE build_req_rcv_sql(p_receipt_num IN VARCHAR2,p_org_id IN NUMBER,p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
1319:
1320: -- Initialize Local Variables.
1321: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
1322: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;
1323:
1324: BEGIN
1325:
1326: p_sql(1) := ' select distinct prh.*' ||

Line 1331: ' rcv_shipment_lines rsl,rcv_shipment_headers rsh'||

1327: ' from po_requisition_headers_all prh,' ||
1328: ' po_requisition_lines_all prl,' ||
1329: ' po_req_distributions_all prd,'||
1330: ' po_line_locations_all pll,po_distributions_all pd,'||
1331: ' rcv_shipment_lines rsl,rcv_shipment_headers rsh'||
1332: ' where prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1333: ' and prl.requisition_header_id = prh.requisition_header_id' ||
1334: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1335: ' and prl.source_type_code = ''VENDOR''' ||

Line 1348: ' rcv_shipment_lines rsl,rcv_shipment_headers rsh'||

1344: ' from po_requisition_headers_all prh,' ||
1345: ' po_requisition_lines_all prl,' ||
1346: ' po_req_distributions_all prd,'||
1347: ' po_line_locations_all pll,po_distributions_all pd,'||
1348: ' rcv_shipment_lines rsl,rcv_shipment_headers rsh'||
1349: ' where prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1350: ' and prl.requisition_header_id = prh.requisition_header_id' ||
1351: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1352: ' and prl.source_type_code = ''VENDOR''' ||

Line 1365: ' rcv_shipment_lines rsl,rcv_shipment_headers rsh'||

1361: ' from po_requisition_headers_all prh,' ||
1362: ' po_requisition_lines_all prl,' ||
1363: ' po_req_distributions_all prd,'||
1364: ' po_line_locations_all pll,po_distributions_all pd,'||
1365: ' rcv_shipment_lines rsl,rcv_shipment_headers rsh'||
1366: ' where prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1367: ' and prl.requisition_header_id = prh.requisition_header_id' ||
1368: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1369: ' and prl.source_type_code = ''VENDOR''' ||

Line 1378: p_sql(4) := ' SELECT distinct ph.* ' ||' from po_headers_all ph,rcv_shipment_lines rsl,rcv_shipment_headers rsh ' ||

1374: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1375: ' AND rsh.ship_to_org_id ='||l_org_id;
1376:
1377:
1378: p_sql(4) := ' SELECT distinct ph.* ' ||' from po_headers_all ph,rcv_shipment_lines rsl,rcv_shipment_headers rsh ' ||
1379: ' WHERE rsh.shipment_header_id=rsl.shipment_header_id' ||
1380: ' and rsl.po_header_id=ph.po_header_id' ||
1381: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1382: ' AND rsh.ship_to_org_id ='||l_org_id;

Line 1385: ' rcv_shipment_headers rsh ' ||' WHERE pl.po_line_id=rsl.po_line_id' ||

1381: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1382: ' AND rsh.ship_to_org_id ='||l_org_id;
1383:
1384: p_sql(5) := ' SELECT distinct pl.* ' ||' from po_lines_all pl,rcv_shipment_lines rsl, ' ||
1385: ' rcv_shipment_headers rsh ' ||' WHERE pl.po_line_id=rsl.po_line_id' ||
1386: ' and rsh.shipment_header_id=rsl.shipment_header_id ' ||' AND rsh.receipt_num='||''''||l_receipt_num||'''' ||
1387: ' AND rsh.ship_to_org_id ='||l_org_id;
1388:
1389: p_sql(6) := ' SELECT distinct pll.* ' ||' from po_line_locations_all pll , ' ||

Line 1390: ' rcv_shipment_lines rsl, ' ||' rcv_shipment_headers rsh' ||

1386: ' and rsh.shipment_header_id=rsl.shipment_header_id ' ||' AND rsh.receipt_num='||''''||l_receipt_num||'''' ||
1387: ' AND rsh.ship_to_org_id ='||l_org_id;
1388:
1389: p_sql(6) := ' SELECT distinct pll.* ' ||' from po_line_locations_all pll , ' ||
1390: ' rcv_shipment_lines rsl, ' ||' rcv_shipment_headers rsh' ||
1391: ' WHERE rsl.po_line_location_id= pll.line_location_id' ||
1392: ' and rsh.shipment_header_id=rsl.shipment_header_id ' ||
1393: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1394: ' AND rsh.ship_to_org_id ='||l_org_id;

Line 1398: ' rcv_shipment_headers rsh ' ||' WHERE pll.line_location_id = pd.line_location_id' ||

1394: ' AND rsh.ship_to_org_id ='||l_org_id;
1395:
1396: p_sql(7) := ' SELECT distinct pd.* ' ||' from po_line_locations_all pll , ' ||
1397: ' po_distributions_all pd,' ||' rcv_shipment_lines rsl, ' ||
1398: ' rcv_shipment_headers rsh ' ||' WHERE pll.line_location_id = pd.line_location_id' ||
1399: ' and rsl.po_line_location_id=pll.line_location_id' ||
1400: ' and rsh.shipment_header_id=rsl.shipment_header_id ' ||
1401: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||' AND rsh.ship_to_org_id ='||l_org_id;
1402:

Line 1405: ' rcv_shipment_lines rsl, ' ||' rcv_shipment_headers rsh' ||

1401: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||' AND rsh.ship_to_org_id ='||l_org_id;
1402:
1403: p_sql(8) := ' SELECT distinct gcc.* ' ||' from gl_code_combinations gcc , ' ||
1404: ' po_line_locations_all pll , ' ||' po_distributions_all pd ,' ||
1405: ' rcv_shipment_lines rsl, ' ||' rcv_shipment_headers rsh' ||
1406: ' WHERE gcc.summary_flag = ''N'' ' ||' AND gcc.template_id is null ' ||
1407: ' AND pll.line_location_id = pd.line_location_id' ||
1408: ' AND pll.line_location_id = rsl.po_line_location_id ' ||
1409: ' and rsh.shipment_header_id=rsl.shipment_header_id ' ||

Line 1416: ' rcv_transactions rt , ' ||' rcv_shipment_headers rsh ' ||

1412: ' and gcc.code_combination_id in (pd.accrual_account_id '||
1413: ', pd.budget_account_id , pd.VARIANCE_ACCOUNT_ID , pd.code_combination_id) ';
1414:
1415: p_sql(9) := ' SELECT distinct rrsl.* ' ||' from rcv_receiving_sub_ledger rrsl , ' ||
1416: ' rcv_transactions rt , ' ||' rcv_shipment_headers rsh ' ||
1417: ' WHERE rsh.receipt_num ='||''''||l_receipt_num||'''' ||' AND rsh.ship_to_org_id ='||l_org_id ||
1418: ' AND rt.shipment_header_id = rsh.shipment_header_id ' ||
1419: ' AND rrsl.rcv_transaction_id = rt.transaction_id ';
1420:

Line 1423: ' rcv_shipment_lines rsl,rcv_shipment_headers rsh ' ||

1419: ' AND rrsl.rcv_transaction_id = rt.transaction_id ';
1420:
1421: /*p_sql(10) := ' SELECT distinct id.* ' ||' from ap_invoice_distributions_all id , ' ||
1422: ' po_line_locations_all pll , ' ||' po_distributions_all pd ,' ||
1423: ' rcv_shipment_lines rsl,rcv_shipment_headers rsh ' ||
1424: ' WHERE pll.line_location_id = pd.line_location_id' ||
1425: ' and pll.line_location_id = rsl.po_line_location_id' ||
1426: ' and rsh.shipment_header_id=rsl.shipment_header_id ' ||
1427: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||

Line 1433: ' rcv_transactions rt,rcv_shipment_headers rsh ' ||

1429: ' AND id.po_distribution_id = pd.po_distribution_id ';*/
1430:
1431: p_sql(10) := ' SELECT distinct id.* ' ||' from ap_invoice_lines_all id , ' ||
1432: ' po_line_locations_all pll ,'||
1433: ' rcv_transactions rt,rcv_shipment_headers rsh ' ||
1434: ' WHERE pll.line_location_id = rt.po_line_location_id' ||
1435: ' and rsh.shipment_header_id=rt.shipment_header_id ' ||
1436: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1437: ' AND rsh.ship_to_org_id ='||l_org_id ||

Line 1443: ' rcv_shipment_headers rsh' ||' WHERE pll.line_location_id = pd.line_location_id' ||

1439:
1440: p_sql(11) := ' SELECT distinct ai.* ' ||' from ap_invoices_all ai , ' ||
1441: ' ap_invoice_distributions_all id , ' ||' po_line_locations_all pll , ' ||
1442: ' po_distributions_all pd ,' ||' rcv_shipment_lines rsl, ' ||
1443: ' rcv_shipment_headers rsh' ||' WHERE pll.line_location_id = pd.line_location_id' ||
1444: ' and pll.line_location_id = rsl.po_line_location_id' ||
1445: ' and rsh.shipment_header_id=rsl.shipment_header_id ' ||
1446: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1447: ' AND rsh.ship_to_org_id ='||l_org_id ||

Line 1453: ' rcv_shipment_headers rsh ' ||' WHERE ph.po_header_id = rsl.po_header_id' ||

1449: ' AND ai.invoice_id = id.invoice_id ';
1450:
1451: p_sql(12) := ' SELECT distinct ili.* ' ||' from ap_invoice_lines_interface ili , ' ||
1452: ' po_headers_all ph,' ||' rcv_shipment_lines rsl, ' ||
1453: ' rcv_shipment_headers rsh ' ||' WHERE ph.po_header_id = rsl.po_header_id' ||
1454: ' and rsh.shipment_header_id=rsl.shipment_header_id ' ||
1455: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1456: ' AND rsh.ship_to_org_id ='||l_org_id ||
1457: ' AND ili.po_header_id = ph.po_header_id ';

Line 1461: ' rcv_shipment_lines rsl, ' ||' rcv_shipment_headers rsh ' ||

1457: ' AND ili.po_header_id = ph.po_header_id ';
1458:
1459: p_sql(13) := ' SELECT distinct ihi.* ' ||' from ap_invoices_interface ihi , ' ||
1460: ' ap_invoice_lines_interface ili , ' ||' po_headers_all ph,' ||
1461: ' rcv_shipment_lines rsl, ' ||' rcv_shipment_headers rsh ' ||
1462: ' WHERE ph.po_header_id = rsl.po_header_id' ||
1463: ' and rsh.shipment_header_id=rsl.shipment_header_id ' ||
1464: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1465: ' AND rsh.ship_to_org_id ='||l_org_id ||

Line 1470: ' rcv_shipment_headers rsh ' ||' WHERE rsh.shipment_header_id =rsl.shipment_header_id ' ||

1466: ' AND ili.po_header_id = ph.po_header_id ' ||
1467: ' AND ihi.invoice_id = ili.invoice_id ';
1468:
1469: p_sql(14) := ' SELECT DISTINCT rsh.* ' ||' from rcv_shipment_lines rsl , ' ||
1470: ' rcv_shipment_headers rsh ' ||' WHERE rsh.shipment_header_id =rsl.shipment_header_id ' ||
1471: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1472: ' AND rsh.ship_to_org_id ='||l_org_id ||
1473: ' AND rsl.shipment_header_id = rsh.shipment_header_id ' ||
1474: ' ORDER BY rsh.shipment_header_id ';

Line 1477: ' rcv_shipment_headers rsh ' ||' WHERE rsh.shipment_header_id =rsl.shipment_header_id ' ||

1473: ' AND rsl.shipment_header_id = rsh.shipment_header_id ' ||
1474: ' ORDER BY rsh.shipment_header_id ';
1475:
1476: p_sql(15) := ' SELECT DISTINCT rsl.* ' ||' from rcv_shipment_lines rsl , ' ||
1477: ' rcv_shipment_headers rsh ' ||' WHERE rsh.shipment_header_id =rsl.shipment_header_id ' ||
1478: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1479: ' AND rsh.ship_to_org_id ='||l_org_id ||
1480: ' AND rsl.shipment_header_id = rsh.shipment_header_id ';
1481:

Line 1483: ' rcv_shipment_headers rsh ' ||' WHERE rsh.receipt_num ='||''''||l_receipt_num||'''' ||

1479: ' AND rsh.ship_to_org_id ='||l_org_id ||
1480: ' AND rsl.shipment_header_id = rsh.shipment_header_id ';
1481:
1482: p_sql(16) := ' SELECT distinct rt.* ' ||' from rcv_transactions rt , ' ||
1483: ' rcv_shipment_headers rsh ' ||' WHERE rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1484: ' AND rsh.ship_to_org_id ='||l_org_id ||
1485: ' AND rt.shipment_header_id=rsh.shipment_header_id ';
1486:
1487: p_sql(17) := ' SELECT distinct ms.* ' ||' from mtl_supply ms , ' ||

Line 1488: ' rcv_shipment_headers rsh ' ||' WHERE rsh.receipt_num ='||''''||l_receipt_num||'''' ||

1484: ' AND rsh.ship_to_org_id ='||l_org_id ||
1485: ' AND rt.shipment_header_id=rsh.shipment_header_id ';
1486:
1487: p_sql(17) := ' SELECT distinct ms.* ' ||' from mtl_supply ms , ' ||
1488: ' rcv_shipment_headers rsh ' ||' WHERE rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1489: ' AND rsh.ship_to_org_id ='||l_org_id ||' AND ms.shipment_header_id=rsh.shipment_header_id ';
1490:
1491: p_sql(18) := ' SELECT distinct rs.* ' ||' from rcv_supply rs , ' ||
1492: ' rcv_shipment_headers rsh ' ||' WHERE rsh.receipt_num ='||''''||l_receipt_num||'''' ||

Line 1492: ' rcv_shipment_headers rsh ' ||' WHERE rsh.receipt_num ='||''''||l_receipt_num||'''' ||

1488: ' rcv_shipment_headers rsh ' ||' WHERE rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1489: ' AND rsh.ship_to_org_id ='||l_org_id ||' AND ms.shipment_header_id=rsh.shipment_header_id ';
1490:
1491: p_sql(18) := ' SELECT distinct rs.* ' ||' from rcv_supply rs , ' ||
1492: ' rcv_shipment_headers rsh ' ||' WHERE rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1493: ' AND rsh.ship_to_org_id ='||l_org_id ||' AND rs.shipment_header_id=rsh.shipment_header_id ';
1494:
1495: p_sql(19) := ' SELECT distinct rhi.* ' ||' from rcv_headers_interface rhi ' ||
1496: ' WHERE receipt_num= '||''''||l_receipt_num||'''' ||' OR exists ' ||

Line 1499: ' rcv_shipment_headers rsh ' ||

1495: p_sql(19) := ' SELECT distinct rhi.* ' ||' from rcv_headers_interface rhi ' ||
1496: ' WHERE receipt_num= '||''''||l_receipt_num||'''' ||' OR exists ' ||
1497: ' (SELECT 1'||
1498: ' from rcv_shipment_lines rsl , ' ||
1499: ' rcv_shipment_headers rsh ' ||
1500: ' WHERE rsh.receipt_num = '||''''||l_receipt_num||'''' ||
1501: ' AND rsh.ship_to_org_id ='||l_org_id ||
1502: ' AND rsl.shipment_header_id = rsh.shipment_header_id ' ||
1503: ' AND rsh.shipment_header_id = rhi.receipt_header_id' ||

Line 1508: ' rcv_shipment_headers rsh ' ||

1504: ' ) ' ||
1505: ' OR exists ' ||
1506: ' (SELECT 2 ' ||
1507: ' from rcv_transactions_interface rti , ' ||
1508: ' rcv_shipment_headers rsh ' ||
1509: ' WHERE rsh.shipment_header_id =rti.shipment_header_id ' ||
1510: ' AND rsh.receipt_num = '||''''||l_receipt_num||'''' ||
1511: ' AND rsh.ship_to_org_id ='||l_org_id ||
1512: ' AND rhi.header_interface_id = rti.header_interface_id' ||

Line 1517: ' from rcv_shipment_headers rsh ' ||

1513: ' ) ';
1514:
1515: p_sql(20) := ' SELECT DISTINCT rti.* ' ||' from rcv_transactions_interface rti ' ||
1516: ' WHERE exists ' ||' (SELECT 1'||
1517: ' from rcv_shipment_headers rsh ' ||
1518: ' WHERE rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1519: ' AND rsh.ship_to_org_id ='||l_org_id ||
1520: ' AND rti.shipment_header_id = rsh.shipment_header_id' ||
1521: ' ) ';

Line 1524: ' rcv_shipment_headers rsh'||' WHERE rsh.receipt_num='||''''||l_receipt_num||'''' ||

1520: ' AND rti.shipment_header_id = rsh.shipment_header_id' ||
1521: ' ) ';
1522:
1523: p_sql(21) := 'SELECT DISTINCT pie.* '||' from po_interface_errors pie , '||
1524: ' rcv_shipment_headers rsh'||' WHERE rsh.receipt_num='||''''||l_receipt_num||'''' ||
1525: ' AND rsh.ship_to_org_id='||l_org_id||' AND ( '||
1526: ' EXISTS (SELECT 1'||' from rcv_transactions_interface rti'||
1527: ' WHERE pie.interface_line_id = rti.interface_transaction_id'||
1528: ' AND rsh.shipment_header_id=rti.shipment_header_id )'||

Line 1535: ' rcv_shipment_headers rsh,' ||' rcv_shipment_lines rsl ' ||

1531: ' WHERE pie.interface_header_id = rhi.header_interface_id '||
1532: ' AND rsh.shipment_header_id = rhi.header_interface_id))';
1533:
1534: p_sql(22) := ' SELECT DISTINCT msi.* ' ||' from mtl_system_items msi , ' ||
1535: ' rcv_shipment_headers rsh,' ||' rcv_shipment_lines rsl ' ||
1536: ' WHERE rsh.shipment_header_id=rsl.shipment_header_id ' ||
1537: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1538: ' AND rsh.ship_to_org_id ='||l_org_id||'and msi.inventory_item_id = rsl.item_id ' ||
1539: ' AND msi.organization_id = rsl.to_organization_id ';

Line 1542: ' from mtl_material_transactions mmt ,rcv_transactions rt,rcv_shipment_headers rsh ,' ||

1538: ' AND rsh.ship_to_org_id ='||l_org_id||'and msi.inventory_item_id = rsl.item_id ' ||
1539: ' AND msi.organization_id = rsl.to_organization_id ';
1540:
1541: p_sql(23) := ' SELECT distinct mmt.* ' ||
1542: ' from mtl_material_transactions mmt ,rcv_transactions rt,rcv_shipment_headers rsh ,' ||
1543: ' po_headers_all ph ' ||' WHERE mmt.transaction_source_id = ph.po_header_id ' ||
1544: ' AND mmt.transaction_source_type_id = 1'||
1545: ' and rsh.shipment_header_id=rt.shipment_header_id ' ||
1546: ' and rt.transaction_id=mmt.rcv_transaction_id' ||

Line 1560: ' rcv_shipment_headers rsh ' ||

1556: ' WHERE exists ' ||
1557: ' (SELECT 1'||
1558: ' from mtl_material_transactions mmt , ' ||
1559: ' rcv_transactions rt,' ||
1560: ' rcv_shipment_headers rsh ' ||
1561: ' WHERE mmt.rcv_transaction_id =rt.transaction_id ' ||
1562: ' AND rt.shipment_header_id =rsh.shipment_header_id ' ||
1563: ' AND mmt.transaction_source_type_id = 1'||
1564: ' AND mtt.transaction_type_id = mmt.transaction_type_id ' ||

Line 1577: ' rcv_shipment_headers rsh ' ||

1573: ' AND mmtt.transaction_type_id = mtt.transaction_type_id ' ||
1574: ' AND (ph.po_header_id in ' ||
1575: ' (SELECT DISTINCT po_header_id ' ||
1576: ' from rcv_shipment_lines rsl, ' ||
1577: ' rcv_shipment_headers rsh ' ||
1578: ' WHERE rsh.shipment_header_id=rsl.shipment_header_id ' ||
1579: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1580: ' AND rsh.ship_to_org_id ='||l_org_id ||' ))' ||' ) ';
1581:

Line 1585: ' rcv_shipment_headers rsh ' ||

1581:
1582: /*p_sql(25) := ' SELECT DISTINCT mol.* ' ||' from mtl_txn_request_lines mol , ' ||
1583: ' rcv_transactions rt , ' ||
1584: ' rcv_shipment_lines rsl , ' ||
1585: ' rcv_shipment_headers rsh ' ||
1586: ' WHERE mol.reference_id = decode(mol.reference ,''SHIPMENT_LINE_ID'' , rt.shipment_line_id ,''PO_LINE_LOCATION_ID'' , rt.po_line_location_id , ''ORDER_LINE_ID'' , rt.oe_order_line_id) ' ||
1587: ' AND rt.shipment_line_id = rsl.shipment_line_id ' ||
1588: ' AND mol.organization_id = rt.organization_id ' ||
1589: ' AND mol.inventory_item_id = rsl.item_id ' ||

Line 1597: ' rcv_shipment_headers rsh ' ||

1593:
1594: p_sql(25) := ' SELECT DISTINCT mol.* ' ||' from mtl_txn_request_lines mol , ' ||
1595: ' rcv_transactions rt , ' ||
1596: ' rcv_shipment_lines rsl , ' ||
1597: ' rcv_shipment_headers rsh ' ||
1598: ' WHERE rt.shipment_line_id = rsl.shipment_line_id ' ||
1599: ' AND mol.organization_id = rt.organization_id ' ||
1600: ' AND mol.inventory_item_id = rsl.item_id ' ||
1601: ' and Nvl(mol.revision,0)=Nvl(rsl.item_revision,0) ' ||

Line 1615: ' rcv_shipment_headers rsh ' ||

1611: ' WHERE mmtt.transaction_source_id = ph.po_header_id ' ||
1612: ' AND (ph.po_header_id in ' ||
1613: ' (SELECT DISTINCT po_header_id ' ||
1614: ' from rcv_shipment_lines rsl, ' ||
1615: ' rcv_shipment_headers rsh ' ||
1616: ' WHERE rsh.shipment_header_id=rsl.shipment_header_id ' ||
1617: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1618: ' AND rsh.ship_to_org_id ='||l_org_id ||
1619: ' )) ';

Line 1627: ' rcv_shipment_headers rsh' ||

1623: ' po_line_locations_all pll , ' ||
1624: ' po_headers_all ph , ' ||
1625: ' financials_system_params_all fsp,' ||
1626: ' rcv_shipment_lines rsl, ' ||
1627: ' rcv_shipment_headers rsh' ||
1628: ' WHERE pll.po_header_id = ph.po_header_id ' ||
1629: ' AND fsp.org_id = ph.org_id ' ||
1630: ' AND ood.organization_id in (fsp.inventory_organization_id , pll.ship_to_organization_id) ' ||
1631: ' AND pll.line_location_id = rsl.po_line_location_id' ||

Line 1642: ' rcv_shipment_headers rsh ' ||

1638: ' po_line_locations_all pll , ' ||
1639: ' po_headers_all ph , ' ||
1640: ' financials_system_params_all fsp,' ||
1641: ' rcv_shipment_lines rsl, ' ||
1642: ' rcv_shipment_headers rsh ' ||
1643: ' WHERE pll.po_header_id = ph.po_header_id ' ||
1644: ' AND fsp.org_id = ph.org_id ' ||
1645: ' AND mp.organization_id in (fsp.inventory_organization_id , pll.ship_to_organization_id) ' ||
1646: ' AND pll.line_location_id = rsl.po_line_location_id' ||

Line 1666: ' rcv_shipment_headers rsh ' ||

1662: ' OR rp.organization_id = pll.ship_to_organization_id) ' ||
1663: ' AND (pll.line_location_id in ' ||
1664: ' (SELECT DISTINCT rsl.po_line_location_id ' ||
1665: ' from rcv_shipment_lines rsl, ' ||
1666: ' rcv_shipment_headers rsh ' ||
1667: ' WHERE rsh.shipment_header_id=rsl.shipment_header_id ' ||
1668: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1669: ' AND rsh.ship_to_org_id ='||l_org_id ||
1670: ' ))';

Line 1677: ' rcv_shipment_headers rsh' ||

1673: p_sql(30):= ' SELECT distinct psp.* ' ||
1674: ' from po_system_parameters_all psp , ' ||
1675: ' po_headers_all ph,' ||
1676: ' rcv_shipment_lines rsl, ' ||
1677: ' rcv_shipment_headers rsh' ||
1678: ' WHERE psp.org_id = ph.org_id ' ||
1679: ' AND ph.po_header_id = rsl.po_header_id' ||
1680: ' AND rsh.shipment_header_id=rsl.shipment_header_id ' ||
1681: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||

Line 1688: ' rcv_shipment_headers rsh' ||

1684: p_sql(31) := ' SELECT distinct fsp.* ' ||
1685: ' from financials_system_params_all fsp , ' ||
1686: ' po_headers_all ph, ' ||
1687: ' rcv_shipment_lines rsl, ' ||
1688: ' rcv_shipment_headers rsh' ||
1689: ' WHERE fsp.org_id = ph.org_id ' ||
1690: ' and ph.po_header_id = rsl.po_header_id' ||
1691: ' and rsh.shipment_header_id=rsl.shipment_header_id ' ||
1692: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||

Line 1699: ' rcv_shipment_headers rsh, ' ||

1695: p_sql(32) := ' SELECT distinct msn.* ' ||
1696: ' from mtl_serial_numbers msn , ' ||
1697: ' mtl_unit_transactions mut , ' ||
1698: ' rcv_transactions rt ,' ||
1699: ' rcv_shipment_headers rsh, ' ||
1700: ' mtl_material_transactions mmt ' ||
1701: ' WHERE mmt.rcv_transaction_id = rt.transaction_id ' ||
1702: ' AND rsh.shipment_header_id =rt.shipment_header_id ' ||
1703: ' AND mmt.transaction_source_type_id = 1'||

Line 1715: ' rcv_shipment_headers rsh, ' ||

1711: ' SELECT distinct msn.* ' ||
1712: ' from mtl_serial_numbers msn , ' ||
1713: ' mtl_unit_transactions mut , ' ||
1714: ' rcv_transactions rt ,' ||
1715: ' rcv_shipment_headers rsh, ' ||
1716: ' mtl_material_transactions mmt, ' ||
1717: ' mtl_transaction_lot_numbers mtln ' ||
1718: ' WHERE mmt.rcv_transaction_id = rt.transaction_id ' ||
1719: ' AND rsh.shipment_header_id =rt.shipment_header_id ' ||

Line 1734: ' rcv_shipment_headers rsh' ||

1730: ' from mtl_serial_numbers_temp msnt , ' ||
1731: ' mtl_material_transactions_temp mmtt, ' ||
1732: ' po_headers_all ph,' ||
1733: ' rcv_shipment_lines rsl,' ||
1734: ' rcv_shipment_headers rsh' ||
1735: ' WHERE mmtt.transaction_source_id = ph.po_header_id ' ||
1736: ' AND msnt.transaction_temp_id = mmtt.transaction_temp_id ' ||
1737: ' AND rsl.po_header_id=ph.po_header_id' ||
1738: ' and rsh.shipment_header_id=rsl.shipment_header_id ' ||

Line 1748: ' rcv_shipment_headers rsh ' ||

1744: ' mtl_material_transactions_temp mmtt , ' ||
1745: ' po_headers_all ph , ' ||
1746: ' mtl_transaction_lots_temp mtln,' ||
1747: ' rcv_shipment_lines rsl,' ||
1748: ' rcv_shipment_headers rsh ' ||
1749: ' WHERE mmtt.transaction_source_id = ph.po_header_id ' ||
1750: ' AND mtln.transaction_temp_id = mmtt.transaction_temp_id ' ||
1751: ' AND msnt.transaction_temp_id = mtln.serial_transaction_temp_id ' ||
1752: ' AND ph.po_header_id = rsl.po_header_id' ||

Line 1760: ' rcv_shipment_headers rsh ' ||

1756:
1757: p_sql(34) := ' SELECT distinct msni.* ' ||
1758: ' from mtl_serial_numbers_interface msni , ' ||
1759: ' rcv_transactions_interface rti ,' ||
1760: ' rcv_shipment_headers rsh ' ||
1761: ' WHERE rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1762: ' AND rsh.ship_to_org_id ='||l_org_id ||
1763: ' AND rti.shipment_header_id =rsh.shipment_header_id ' ||
1764: ' AND msni.product_transaction_id = rti.interface_transaction_id';

Line 1769: ' rcv_shipment_headers rsh, ' ||

1765:
1766: p_sql(35):=' SELECT distinct mut.* ' ||
1767: ' from mtl_unit_transactions mut , ' ||
1768: ' rcv_transactions rt ,' ||
1769: ' rcv_shipment_headers rsh, ' ||
1770: ' mtl_material_transactions mmt ' ||
1771: ' WHERE mmt.rcv_transaction_id = rt.transaction_id ' ||
1772: ' AND rsh.shipment_header_id =rt.shipment_header_id ' ||
1773: ' AND mmt.transaction_source_type_id = 1'||

Line 1781: ' rcv_shipment_headers rsh, ' ||

1777: ' UNION ALL ' ||
1778: ' SELECT mut.* ' ||
1779: ' from mtl_unit_transactions mut, ' ||
1780: ' rcv_transactions rt ,' ||
1781: ' rcv_shipment_headers rsh, ' ||
1782: ' mtl_material_transactions mmt , ' ||
1783: ' mtl_transaction_lot_numbers mtln ' ||
1784: ' WHERE mmt.rcv_transaction_id = rt.transaction_id ' ||
1785: ' AND rsh.shipment_header_id =rt.shipment_header_id ' ||

Line 1796: ' rcv_shipment_headers rsh ' ||

1792:
1793: p_sql(36):=' SELECT distinct rss.* ' ||
1794: ' from rcv_serials_supply rss , ' ||
1795: ' rcv_shipment_lines rsl, ' ||
1796: ' rcv_shipment_headers rsh ' ||
1797: ' WHERE rss.shipment_line_id = rsl.shipment_line_id ' ||
1798: ' AND rsh.shipment_header_id=rsl.shipment_header_id ' ||
1799: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1800: ' AND rsh.ship_to_org_id ='||l_org_id;

Line 1805: ' rcv_shipment_headers rsh ' ||

1801:
1802: p_sql(37):=' SELECT distinct rst.* ' ||
1803: ' from rcv_serial_transactions rst , ' ||
1804: ' rcv_shipment_lines rsl , ' ||
1805: ' rcv_shipment_headers rsh ' ||
1806: ' WHERE rst.shipment_line_id = rsl.shipment_line_id ' ||
1807: ' AND rsh.shipment_header_id=rsl.shipment_header_id ' ||
1808: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1809: ' AND rsh.ship_to_org_id ='||l_org_id;

Line 1814: ' rcv_shipment_headers rsh ' ||

1810:
1811: p_sql(38):=' SELECT distinct rsi.* ' ||
1812: ' from rcv_serials_interface rsi , ' ||
1813: ' rcv_transactions_interface rti , ' ||
1814: ' rcv_shipment_headers rsh ' ||
1815: ' WHERE rti.shipment_header_id = rsh.shipment_header_id ' ||
1816: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1817: ' AND rsh.ship_to_org_id ='||l_org_id ||
1818: ' AND rsi.interface_transaction_id = rti.interface_transaction_id ';

Line 1824: ' rcv_shipment_headers rsh, ' ||

1820: p_sql(39):=' SELECT distinct mln.* ' ||
1821: ' from mtl_lot_numbers mln , ' ||
1822: ' mtl_transaction_lot_numbers mtln , ' ||
1823: ' rcv_transactions rt ,' ||
1824: ' rcv_shipment_headers rsh, ' ||
1825: ' mtl_material_transactions mmt ' ||
1826: ' WHERE mmt.rcv_transaction_id = rt.transaction_id ' ||
1827: ' AND rsh.shipment_header_id =rt.shipment_header_id ' ||
1828: ' AND mmt.transaction_source_type_id = 1'||

Line 1839: ' rcv_shipment_headers rsh, ' ||

1835:
1836: p_sql(40):=' SELECT distinct mtln.* ' ||
1837: ' from mtl_transaction_lot_numbers mtln , ' ||
1838: ' rcv_transactions rt ,' ||
1839: ' rcv_shipment_headers rsh, ' ||
1840: ' mtl_material_transactions mmt ' ||
1841: ' WHERE mmt.rcv_transaction_id = rt.transaction_id ' ||
1842: ' AND rsh.shipment_header_id =rt.shipment_header_id ' ||
1843: ' AND mmt.transaction_source_type_id = 1'||

Line 1851: ' rcv_shipment_headers rsh ' ||

1847:
1848: p_sql(41):=' SELECT distinct mtli.* ' ||
1849: ' from mtl_transaction_lots_interface mtli , ' ||
1850: ' rcv_transactions_interface rti ,' ||
1851: ' rcv_shipment_headers rsh ' ||
1852: ' WHERE rti.shipment_header_id = rsh.shipment_header_id ' ||
1853: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1854: ' AND rsh.ship_to_org_id ='||l_org_id ||
1855: ' AND mtli.product_transaction_id = RTI.interface_transaction_id';

Line 1867: ' rcv_shipment_headers rsh ' ||

1863: ' AND mmtt.transaction_temp_id = mtlt.transaction_temp_id ' ||
1864: ' AND (ph.po_header_id in ' ||
1865: ' (SELECT DISTINCT po_header_id ' ||
1866: ' from rcv_shipment_lines rsl, ' ||
1867: ' rcv_shipment_headers rsh ' ||
1868: ' WHERE rsh.shipment_header_id=rsl.shipment_header_id ' ||
1869: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1870: ' AND rsh.ship_to_org_id ='||l_org_id ||' ))';
1871:

Line 1875: ' rcv_shipment_headers rsh ' ||

1871:
1872: p_sql(43):=' SELECT distinct rls.* ' ||
1873: ' from rcv_lots_supply rls , ' ||
1874: ' rcv_shipment_lines rsl , ' ||
1875: ' rcv_shipment_headers rsh ' ||
1876: ' WHERE rsl.shipment_line_id = rls.shipment_line_id ' ||
1877: ' AND rsh.shipment_header_id=rsl.shipment_header_id ' ||
1878: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1879: ' AND rsh.ship_to_org_id ='||l_org_id;

Line 1884: ' rcv_shipment_headers rsh ' ||

1880:
1881: p_sql(44):=' SELECT distinct rlt.* ' ||
1882: ' from rcv_lot_transactions rlt , ' ||
1883: ' rcv_shipment_lines rsl , ' ||
1884: ' rcv_shipment_headers rsh ' ||
1885: ' WHERE rsl.shipment_line_id = rlt.shipment_line_id ' ||
1886: ' AND rsh.shipment_header_id=rsl.shipment_header_id ' ||
1887: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1888: ' AND rsh.ship_to_org_id ='||l_org_id;

Line 1893: ' rcv_shipment_headers rsh ' ||

1889:
1890: p_sql(45):=' SELECT distinct rli.* ' ||
1891: ' from rcv_lots_interface rli , ' ||
1892: ' rcv_transactions_interface rti,' ||
1893: ' rcv_shipment_headers rsh ' ||
1894: ' WHERE rti.interface_transaction_id = rli.interface_transaction_id ' ||
1895: ' AND rti.shipment_header_id =rsh.shipment_header_id ' ||
1896: ' AND rsh.receipt_num ='||''''||l_receipt_num||'''' ||
1897: ' AND rsh.ship_to_org_id ='||l_org_id;

Line 1916: l_receipt_number rcv_shipment_headers.receipt_num%TYPE := p_receipt_number;

1912:
1913: -- Initialize Local Variables.
1914: l_operating_id po_requisition_headers_all.org_id%TYPE := p_operating_id;
1915: l_req_number po_requisition_headers_all.segment1%TYPE := p_req_number;
1916: l_receipt_number rcv_shipment_headers.receipt_num%TYPE := p_receipt_number;
1917: l_line_num VARCHAR2(1000) := p_line_num;
1918: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;
1919:
1920: BEGIN

Line 1918: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;

1914: l_operating_id po_requisition_headers_all.org_id%TYPE := p_operating_id;
1915: l_req_number po_requisition_headers_all.segment1%TYPE := p_req_number;
1916: l_receipt_number rcv_shipment_headers.receipt_num%TYPE := p_receipt_number;
1917: l_line_num VARCHAR2(1000) := p_line_num;
1918: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;
1919:
1920: BEGIN
1921:
1922: -- Build the condition based on the input

Line 1940: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl,

1936:
1937: p_sql(2) := ' select distinct prl.*' ||
1938: ' from po_requisition_lines_all prl,' ||
1939: ' po_requisition_headers_all prh, ' ||
1940: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl,
1941: po_line_locations_all pll ' ||
1942: ' where prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1943: ' and pll.line_location_id = prl.line_location_id ' ||
1944: ' and rsh.shipment_header_id = rsl.shipment_header_id ' ||

Line 1959: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl,

1955: p_sql(3) := ' select distinct prd.*' ||
1956: ' from po_req_distributions_all prd ,' ||
1957: ' po_requisition_lines_all prl ,' ||
1958: ' po_requisition_headers_all prh,' ||
1959: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl,
1960: po_line_locations_all pll ' ||
1961: ' where prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1962: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1963: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 1981: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||

1977: ' po_distributions_all pd,' ||
1978: ' po_req_distributions_all prd ,' ||
1979: ' po_requisition_lines_all prl ,' ||
1980: ' po_requisition_headers_all prh,' ||
1981: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||
1982: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
1983: ' and prh.requisition_header_id = prl.requisition_header_id' ||
1984: ' and prl.requisition_line_id = prd.requisition_line_id' ||
1985: ' and prl.source_type_code = ''VENDOR''' ||

Line 2004: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||

2000: ' po_distributions_all pd,' ||
2001: ' po_req_distributions_all prd ,' ||
2002: ' po_requisition_lines_all prl ,' ||
2003: ' po_requisition_headers_all prh,' ||
2004: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||
2005: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2006: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2007: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2008: ' and prl.source_type_code = ''VENDOR''' ||

Line 2029: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||

2025: ' po_distributions_all pd,' ||
2026: ' po_req_distributions_all prd ,' ||
2027: ' po_requisition_lines_all prl ,' ||
2028: ' po_requisition_headers_all prh,' ||
2029: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||
2030: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2031: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2032: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2033: ' and prl.source_type_code = ''VENDOR''' ||

Line 2056: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||

2052: ' po_distributions_all pd,' ||
2053: ' po_req_distributions_all prd ,' ||
2054: ' po_requisition_lines_all prl ,' ||
2055: ' po_requisition_headers_all prh ,' ||
2056: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||
2057: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2058: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2059: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2060: ' and prl.source_type_code = ''VENDOR''' ||

Line 2111: ' rcv_shipment_headers rsh ' ||

2107: ' po_distributions_all pd,' ||
2108: ' po_req_distributions_all prd ,' ||
2109: ' po_requisition_lines_all prl ,' ||
2110: ' po_requisition_headers_all prh, ' ||
2111: ' rcv_shipment_headers rsh ' ||
2112: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2113: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2114: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2115: ' and prl.source_type_code = ''VENDOR''' ||

Line 2139: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||

2135: ' po_distributions_all pd,' ||
2136: ' po_req_distributions_all prd ,' ||
2137: ' po_requisition_lines_all prl ,' ||
2138: ' po_requisition_headers_all prh, ' ||
2139: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||
2140: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2141: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2142: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2143: ' and prl.source_type_code = ''VENDOR''' ||

Line 2167: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||

2163: ' po_distributions_all pd,' ||
2164: ' po_req_distributions_all prd ,' ||
2165: ' po_requisition_lines_all prl ,' ||
2166: ' po_requisition_headers_all prh, ' ||
2167: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
2168: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2169: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2170: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2171: ' and prl.source_type_code = ''VENDOR''' ||

Line 2198: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||

2194: ' po_distributions_all pd,' ||
2195: ' po_req_distributions_all prd ,' ||
2196: ' po_requisition_lines_all prl ,' ||
2197: ' po_requisition_headers_all prh, ' ||
2198: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||
2199: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2200: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2201: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2202: ' and prl.source_type_code = ''VENDOR''' ||

Line 2227: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||

2223: ' po_distributions_all pd,' ||
2224: ' po_req_distributions_all prd ,' ||
2225: ' po_requisition_lines_all prl ,' ||
2226: ' po_requisition_headers_all prh, ' ||
2227: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||
2228: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2229: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2230: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2231: ' and prl.source_type_code = ''VENDOR''' ||

Line 2255: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||

2251: ' po_distributions_all pd,' ||
2252: ' po_req_distributions_all prd ,' ||
2253: ' po_requisition_lines_all prl ,' ||
2254: ' po_requisition_headers_all prh, ' ||
2255: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||
2256: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2257: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2258: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2259: ' and prl.source_type_code = ''VENDOR''' ||

Line 2277: ' rcv_shipment_headers rsh, ' ||

2273: ' and prh.org_id = '||l_operating_id;
2274:
2275: p_sql(14) := ' SELECT DISTINCT rsh.* ' ||
2276: ' from rcv_shipment_lines rsl , ' ||
2277: ' rcv_shipment_headers rsh, ' ||
2278: ' po_line_locations_all pll , ' ||
2279: ' po_distributions_all pd,' ||
2280: ' po_req_distributions_all prd ,' ||
2281: ' po_requisition_lines_all prl ,' ||

Line 2299: ' rcv_shipment_headers rsh, ' ||

2295: ' and prh.org_id = '||l_operating_id;
2296:
2297: p_sql(15) := ' SELECT DISTINCT rsl.* ' ||
2298: ' from rcv_shipment_lines rsl , ' ||
2299: ' rcv_shipment_headers rsh, ' ||
2300: ' po_line_locations_all pll , ' ||
2301: ' po_distributions_all pd,' ||
2302: ' po_req_distributions_all prd ,' ||
2303: ' po_requisition_lines_all prl ,' ||

Line 2321: ' rcv_shipment_headers rsh, ' ||

2317: ' and prh.org_id = '||l_operating_id;
2318:
2319: p_sql(16) := ' SELECT DISTINCT rt.* ' ||
2320: ' from rcv_transactions rt , ' ||
2321: ' rcv_shipment_headers rsh, ' ||
2322: ' po_line_locations_all pll , ' ||
2323: ' po_distributions_all pd,' ||
2324: ' po_req_distributions_all prd ,' ||
2325: ' po_requisition_lines_all prl ,' ||

Line 2349: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl'||

2345: ' po_distributions_all pd,' ||
2346: ' po_req_distributions_all prd ,' ||
2347: ' po_requisition_lines_all prl ,' ||
2348: ' po_requisition_headers_all prh ,' ||
2349: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl'||
2350: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2351: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2352: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2353: ' and prl.source_type_code = ''VENDOR''' ||

Line 2371: ' po_requisition_headers_all prh , rcv_shipment_headers rsh,

2367: ' po_line_locations_all pll , ' ||
2368: ' po_distributions_all pd,' ||
2369: ' po_req_distributions_all prd ,' ||
2370: ' po_requisition_lines_all prl ,' ||
2371: ' po_requisition_headers_all prh , rcv_shipment_headers rsh,
2372: rcv_shipment_lines rsl ' ||
2373: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2374: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2375: ' and prl.requisition_line_id = prd.requisition_line_id' ||

Line 2393: ' rcv_shipment_headers rsh, ' ||

2389: ' from rcv_headers_interface rhi ' ||
2390: ' WHERE exists ' ||
2391: ' (SELECT 1 ' ||
2392: ' from rcv_shipment_lines rsl , ' ||
2393: ' rcv_shipment_headers rsh, ' ||
2394: ' po_line_locations_all pll , ' ||
2395: ' po_lines_all pl , ' ||
2396: ' po_headers_all ph , ' ||
2397: ' po_distributions_all pd,' ||

Line 2479: ' from rcv_transactions_interface rti, rcv_shipment_headers rsh' ||

2475: ' and prh.org_id = '||l_operating_id||
2476: ' ) ' ||
2477: 'union' ||
2478: ' select rti.*' ||
2479: ' from rcv_transactions_interface rti, rcv_shipment_headers rsh' ||
2480: ' where rsh.receipt_num = '||''''||l_receipt_number||'''' ||
2481: ' and rsh.ship_to_org_id = '|| l_org_id ||
2482: ' and rti.shipment_header_id = rsh.shipment_header_id ' ;
2483:

Line 2509: ' mtl_system_items msi , po_line_locations_all pll, rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||

2505:
2506: p_sql(22) := ' select distinct msi.*' ||
2507: ' from po_requisition_lines_all prl,' ||
2508: ' po_requisition_headers_all prh,' ||
2509: ' mtl_system_items msi , po_line_locations_all pll, rcv_shipment_headers rsh, rcv_shipment_lines rsl ' ||
2510: ' where prh.segment1 = '||''''||l_req_number||''''||
2511: ' and prh.org_id = '||l_operating_id||
2512: ' and prl.line_num='||l_line_num||
2513: ' and prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||

Line 2533: ' rcv_shipment_headers rsh, rcv_transactions rt' ||

2529: ' po_distributions_all pd,' ||
2530: ' po_req_distributions_all prd ,' ||
2531: ' po_requisition_lines_all prl ,' ||
2532: ' po_requisition_headers_all prh, ' ||
2533: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
2534: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2535: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2536: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2537: ' and prl.source_type_code = ''VENDOR''' ||

Line 2571: ' rcv_shipment_headers rsh, rcv_transactions rt' ||

2567: ' po_distributions_all pd,' ||
2568: ' po_req_distributions_all prd ,' ||
2569: ' po_requisition_lines_all prl ,' ||
2570: ' po_requisition_headers_all prh, ' ||
2571: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
2572: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2573: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2574: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2575: ' and prl.source_type_code = ''VENDOR''' ||

Line 2604: ' rcv_shipment_headers rsh, rcv_transactions rt' ||

2600: ' po_distributions_all pd,' ||
2601: ' po_req_distributions_all prd ,' ||
2602: ' po_requisition_lines_all prl ,' ||
2603: ' po_requisition_headers_all prh, ' ||
2604: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
2605: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2606: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2607: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2608: ' and prl.source_type_code = ''VENDOR''' ||

Line 2636: ' rcv_shipment_headers rsh '||

2632: ' po_distributions_all pd,' ||
2633: ' po_req_distributions_all prd ,' ||
2634: ' po_requisition_lines_all prl ,' ||
2635: ' po_requisition_headers_all prh, ' ||
2636: ' rcv_shipment_headers rsh '||
2637: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2638: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2639: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2640: ' and prl.source_type_code = ''VENDOR''' ||

Line 2666: ' rcv_shipment_headers rsh '||

2662: ' po_distributions_all pd,' ||
2663: ' po_req_distributions_all prd ,' ||
2664: ' po_requisition_lines_all prl ,' ||
2665: ' po_requisition_headers_all prh, ' ||
2666: ' rcv_shipment_headers rsh '||
2667: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2668: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2669: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2670: ' and prl.source_type_code = ''VENDOR''' ||

Line 2696: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||

2692: ' po_distributions_all pd,' ||
2693: ' po_req_distributions_all prd ,' ||
2694: ' po_requisition_lines_all prl ,' ||
2695: ' po_requisition_headers_all prh, ' ||
2696: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
2697: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2698: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2699: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2700: ' and prl.source_type_code = ''VENDOR''' ||

Line 2812: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||

2808: ' po_distributions_all pd,' ||
2809: ' po_req_distributions_all prd ,' ||
2810: ' po_requisition_lines_all prl ,' ||
2811: ' po_requisition_headers_all prh,' ||
2812: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
2813: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2814: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2815: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2816: ' and prl.source_type_code = ''VENDOR''' ||

Line 2848: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||

2844: ' po_distributions_all pd,' ||
2845: ' po_req_distributions_all prd ,' ||
2846: ' po_requisition_lines_all prl ,' ||
2847: ' po_requisition_headers_all prh, ' ||
2848: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
2849: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2850: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2851: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2852: ' and prl.source_type_code = ''VENDOR''' ||

Line 2884: ' rcv_shipment_headers rsh, rcv_transactions rt' ||

2880: ' po_distributions_all pd,' ||
2881: ' po_req_distributions_all prd ,' ||
2882: ' po_requisition_lines_all prl ,' ||
2883: ' po_requisition_headers_all prh, ' ||
2884: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
2885: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2886: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2887: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2888: ' and prl.source_type_code = ''VENDOR''' ||

Line 2915: ' rcv_shipment_headers rsh, rcv_transactions rt' ||

2911: ' po_distributions_all pd,' ||
2912: ' po_req_distributions_all prd ,' ||
2913: ' po_requisition_lines_all prl ,' ||
2914: ' po_requisition_headers_all prh ,' ||
2915: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
2916: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2917: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2918: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2919: ' and prl.source_type_code = ''VENDOR''' ||

Line 2949: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl' ||

2945: ' po_distributions_all pd,' ||
2946: ' po_req_distributions_all prd ,' ||
2947: ' po_requisition_lines_all prl ,' ||
2948: ' po_requisition_headers_all prh, ' ||
2949: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl' ||
2950: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2951: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2952: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2953: ' and prl.source_type_code = ''VENDOR''' ||

Line 2981: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||

2977: ' po_distributions_all pd,' ||
2978: ' po_req_distributions_all prd ,' ||
2979: ' po_requisition_lines_all prl ,' ||
2980: ' po_requisition_headers_all prh, ' ||
2981: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
2982: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
2983: ' and prh.requisition_header_id = prl.requisition_header_id' ||
2984: ' and prl.requisition_line_id = prd.requisition_line_id' ||
2985: ' and prl.source_type_code = ''VENDOR''' ||

Line 3013: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||

3009: ' po_distributions_all pd,' ||
3010: ' po_req_distributions_all prd ,' ||
3011: ' po_requisition_lines_all prl ,' ||
3012: ' po_requisition_headers_all prh, ' ||
3013: ' rcv_shipment_headers rsh, rcv_transactions rt ' ||
3014: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3015: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3016: ' and prl.requisition_line_id = prd.requisition_line_id' ||
3017: ' and prl.source_type_code = ''VENDOR''' ||

Line 3045: ' rcv_shipment_headers rsh ' ||

3041: ' po_distributions_all pd,' ||
3042: ' po_req_distributions_all prd ,' ||
3043: ' po_requisition_lines_all prl ,' ||
3044: ' po_requisition_headers_all prh, ' ||
3045: ' rcv_shipment_headers rsh ' ||
3046: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3047: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3048: ' and prl.requisition_line_id = prd.requisition_line_id' ||
3049: ' and prl.source_type_code = ''VENDOR''' ||

Line 3074: ' rcv_shipment_headers rsh ' ||

3070: ' po_distributions_all pd,' ||
3071: ' po_req_distributions_all prd ,' ||
3072: ' po_requisition_lines_all prl ,' ||
3073: ' po_requisition_headers_all prh, ' ||
3074: ' rcv_shipment_headers rsh ' ||
3075: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3076: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3077: ' and prl.requisition_line_id = prd.requisition_line_id' ||
3078: ' and prl.source_type_code = ''VENDOR''' ||

Line 3105: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||

3101: ' po_distributions_all pd,' ||
3102: ' po_req_distributions_all prd ,' ||
3103: ' po_requisition_lines_all prl ,' ||
3104: ' po_requisition_headers_all prh, ' ||
3105: ' rcv_shipment_headers rsh, rcv_shipment_lines rsl '||
3106: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3107: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3108: ' and prl.requisition_line_id = prd.requisition_line_id' ||
3109: ' and prl.source_type_code = ''VENDOR''' ||

Line 3138: ' rcv_shipment_headers rsh, rcv_transactions rt' ||

3134: ' po_distributions_all pd,' ||
3135: ' po_req_distributions_all prd ,' ||
3136: ' po_requisition_lines_all prl ,' ||
3137: ' po_requisition_headers_all prh, ' ||
3138: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
3139: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3140: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3141: ' and prl.requisition_line_id = prd.requisition_line_id' ||
3142: ' and prl.source_type_code = ''VENDOR''' ||

Line 3173: ' rcv_shipment_headers rsh, rcv_transactions rt' ||

3169: ' po_distributions_all pd,' ||
3170: ' po_req_distributions_all prd ,' ||
3171: ' po_requisition_lines_all prl ,' ||
3172: ' po_requisition_headers_all prh, ' ||
3173: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
3174: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3175: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3176: ' and prl.requisition_line_id = prd.requisition_line_id' ||
3177: ' and prl.source_type_code = ''VENDOR''' ||

Line 3234: ' rcv_shipment_headers rsh, rcv_transactions rt' ||

3230: ' po_distributions_all pd,' ||
3231: ' po_req_distributions_all prd ,' ||
3232: ' po_requisition_lines_all prl ,' ||
3233: ' po_requisition_headers_all prh, ' ||
3234: ' rcv_shipment_headers rsh, rcv_transactions rt' ||
3235: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3236: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3237: ' and prl.requisition_line_id = prd.requisition_line_id' ||
3238: ' and prl.source_type_code = ''VENDOR''' ||

Line 3265: ' rcv_shipment_headers rsh ' ||

3261: ' po_distributions_all pd,' ||
3262: ' po_req_distributions_all prd ,' ||
3263: ' po_requisition_lines_all prl ,' ||
3264: ' po_requisition_headers_all prh, ' ||
3265: ' rcv_shipment_headers rsh ' ||
3266: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3267: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3268: ' and prl.requisition_line_id = prd.requisition_line_id' ||
3269: ' and prl.source_type_code = ''VENDOR''' ||

Line 3296: ' rcv_shipment_headers rsh ' ||

3292: ' po_distributions_all pd,' ||
3293: ' po_req_distributions_all prd ,' ||
3294: ' po_requisition_lines_all prl ,' ||
3295: ' po_requisition_headers_all prh, ' ||
3296: ' rcv_shipment_headers rsh ' ||
3297: ' WHERE prh.type_lookup_code in (''INTERNAL'', ''PURCHASE'')' ||
3298: ' and prh.requisition_header_id = prl.requisition_header_id' ||
3299: ' and prl.requisition_line_id = prd.requisition_line_id' ||
3300: ' and prl.source_type_code = ''VENDOR''' ||