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.WSH_PR_PICKING_SESSION dependencies on SO_LINES_ALL

Line 208: FROM SO_LINES_ALL

204:
205: -- cursor to get line information
206: CURSOR get_line_info(x_line_id In BINARY_INTEGER) IS
207: SELECT HEADER_ID, NVL(PARENT_LINE_ID, -1)
208: FROM SO_LINES_ALL
209: WHERE LINE_ID = x_line_id;
210:
211: record_locked EXCEPTION;
212: PRAGMA EXCEPTION_INIT(record_locked, -54);

Line 1062: Process_Buffer('u', ' SO_LINES_ALL L ');

1058: Process_Buffer('u', ' WSH_DEPARTURES DP, ');
1059: Process_Buffer('u', ' SO_LINE_DETAILS LD, ');
1060: Process_Buffer('u', ' SO_HEADERS_ALL H, ');
1061: IF (header_id <> 0 OR departure_id <> 0 OR order_line_id <>0) THEN
1062: Process_Buffer('u', ' SO_LINES_ALL L ');
1063: ELSE
1064: -- inline view to use index on S2. This is for performance improvement.
1065: Process_Buffer('u', ' (SELECT * FROM SO_LINES_ALL SL');
1066: Process_Buffer('u', ' WHERE SL.S2 IN (18,5) AND ');

Line 1065: Process_Buffer('u', ' (SELECT * FROM SO_LINES_ALL SL');

1061: IF (header_id <> 0 OR departure_id <> 0 OR order_line_id <>0) THEN
1062: Process_Buffer('u', ' SO_LINES_ALL L ');
1063: ELSE
1064: -- inline view to use index on S2. This is for performance improvement.
1065: Process_Buffer('u', ' (SELECT * FROM SO_LINES_ALL SL');
1066: Process_Buffer('u', ' WHERE SL.S2 IN (18,5) AND ');
1067: Process_Buffer('u', ' ROWNUM > 0) L ');
1068: END IF;
1069: Process_Buffer('u', ' WHERE L.HEADER_ID = H.HEADER_ID ');

Line 1263: Process_Buffer('b', ' SO_LINES_ALL L, ');

1259: Process_Buffer('b', ' FROM WSH_DELIVERIES DL, ');
1260: Process_Buffer('b', ' WSH_DEPARTURES DP, ');
1261: Process_Buffer('b', ' SO_PICKING_LINE_DETAILS PLD, ');
1262: IF (header_id <> 0 OR departure_id <> 0 OR order_line_id <> 0) THEN
1263: Process_Buffer('b', ' SO_LINES_ALL L, ');
1264: ELSE
1265: -- inline view to use index on S3. This is for performance improvement.
1266: Process_Buffer('b', ' (SELECT * FROM SO_LINES_ALL SL');
1267: Process_Buffer('b', ' WHERE SL.S3 IN (18,5) AND ');

Line 1266: Process_Buffer('b', ' (SELECT * FROM SO_LINES_ALL SL');

1262: IF (header_id <> 0 OR departure_id <> 0 OR order_line_id <> 0) THEN
1263: Process_Buffer('b', ' SO_LINES_ALL L, ');
1264: ELSE
1265: -- inline view to use index on S3. This is for performance improvement.
1266: Process_Buffer('b', ' (SELECT * FROM SO_LINES_ALL SL');
1267: Process_Buffer('b', ' WHERE SL.S3 IN (18,5) AND ');
1268: Process_Buffer('b', ' ROWNUM > 0) L, ');
1269: END IF;
1270: Process_Buffer('b', ' SO_HEADERS_ALL H, ');

Line 1434: Process_Buffer('s', ' SO_LINES_ALL L ');

1430: Process_Buffer('s', ' FROM WSH_DELIVERIES DL, ');
1431: Process_Buffer('s', ' WSH_DEPARTURES DP, ');
1432: Process_Buffer('s', ' SO_LINE_DETAILS LD, ');
1433: Process_Buffer('s', ' SO_HEADERS_ALL H, ');
1434: Process_Buffer('s', ' SO_LINES_ALL L ');
1435: Process_Buffer('s', ' WHERE L.HEADER_ID = H.HEADER_ID ');
1436: Process_Buffer('s', ' AND L.LINE_ID = LD.LINE_ID ');
1437: Process_Buffer('s', ' AND LD.DEPARTURE_ID = DP.DEPARTURE_ID (+) ');
1438: Process_Buffer('s', ' AND LD.DELIVERY_ID = DL.DELIVERY_ID (+) ');

Line 1454: Process_Buffer('s', ' (SELECT L1.LINE_ID FROM SO_LINES_ALL L1 ');

1450: Process_Buffer('s', ' DECODE(LD.SCHEDULE_STATUS_CODE,''RESERVED'',''Y'',''N''),''X'') = ');
1451: Process_Buffer('s', ' DECODE(L.ATO_FLAG,''Y'',''Y'',''X'') ');
1452:
1453: Process_Buffer('s', ' AND L.LINE_ID IN ');
1454: Process_Buffer('s', ' (SELECT L1.LINE_ID FROM SO_LINES_ALL L1 ');
1455: Process_Buffer('s', ' WHERE L1.LINE_ID = :X_p_param_1 ');
1456: Process_Buffer('s', ' UNION ');
1457: Process_Buffer('s', ' SELECT L2.LINE_ID FROM SO_LINES_ALL L2 ');
1458: Process_Buffer('s', ' WHERE L2.PARENT_LINE_ID = :X_p_param_1) ');

Line 1457: Process_Buffer('s', ' SELECT L2.LINE_ID FROM SO_LINES_ALL L2 ');

1453: Process_Buffer('s', ' AND L.LINE_ID IN ');
1454: Process_Buffer('s', ' (SELECT L1.LINE_ID FROM SO_LINES_ALL L1 ');
1455: Process_Buffer('s', ' WHERE L1.LINE_ID = :X_p_param_1 ');
1456: Process_Buffer('s', ' UNION ');
1457: Process_Buffer('s', ' SELECT L2.LINE_ID FROM SO_LINES_ALL L2 ');
1458: Process_Buffer('s', ' WHERE L2.PARENT_LINE_ID = :X_p_param_1) ');
1459:
1460: Process_Buffer('s', ' AND L.S2 IN (18,5) ');
1461:

Line 1521: Process_Buffer('n', ' SO_LINES_ALL L ');

1517: Process_Buffer('n', ' NVL(LD.LINE_DETAIL_ID, -1), ');
1518: Process_Buffer('n', ' NVL(H.ORG_ID, -3114) ');
1519: Process_Buffer('n', ' FROM SO_LINE_DETAILS LD, ');
1520: Process_Buffer('n', ' SO_HEADERS_ALL H, ');
1521: Process_Buffer('n', ' SO_LINES_ALL L ');
1522: Process_Buffer('n', ' WHERE L.HEADER_ID = H.HEADER_ID ');
1523: Process_Buffer('n', ' AND L.LINE_ID = LD.LINE_ID(+) ');
1524: Process_Buffer('n', ' AND L.SOURCE_TYPE_CODE = ''INTERNAL'' ');
1525: Process_Buffer('n', ' AND NVL(L.CANCELLED_QUANTITY,0) < L.ORDERED_QUANTITY ');

Line 1541: Process_Buffer('n', ' FROM SO_LINES_ALL L2, ');

1537: Process_Buffer('n', ' OR (L.ITEM_TYPE_CODE IN (''MODEL'',''KIT'',''CLASS'') ');
1538: Process_Buffer('n', ' AND L.REQUEST_ID = :X_request_id ');
1539: Process_Buffer('n', ' AND NOT EXISTS ( ');
1540: Process_Buffer('n', ' SELECT ''shippable component for a model'' ');
1541: Process_Buffer('n', ' FROM SO_LINES_ALL L2, ');
1542: Process_Buffer('n', ' SO_LINE_DETAILS LD2 ');
1543: Process_Buffer('n', ' WHERE L2.LINE_ID = NVL(L.PARENT_LINE_ID,L.LINE_ID) ');
1544: Process_Buffer('n', ' AND L2.LINE_ID = LD2.LINE_ID ');
1545: Process_Buffer('n', ' AND LD2.RELEASED_FLAG = ''N'' ');

Line 1549: Process_Buffer('n', ' FROM SO_LINES_ALL L3, ');

1545: Process_Buffer('n', ' AND LD2.RELEASED_FLAG = ''N'' ');
1546: Process_Buffer('n', ' AND LD2.SHIPPABLE_FLAG = ''Y'' ');
1547: Process_Buffer('n', ' UNION ');
1548: Process_Buffer('n', ' SELECT ''shippable component for model components'' ');
1549: Process_Buffer('n', ' FROM SO_LINES_ALL L3, ');
1550: Process_Buffer('n', ' SO_LINE_DETAILS LD3 ');
1551: Process_Buffer('n', ' WHERE L3.PARENT_LINE_ID = NVL(L.PARENT_LINE_ID,L.LINE_ID) ');
1552: Process_Buffer('n', ' AND L3.LINE_ID = LD3.LINE_ID ');
1553: Process_Buffer('n', ' AND LD3.RELEASED_FLAG = ''N'' ');

Line 1607: Process_Buffer('n', ' FROM SO_LINES_ALL L1, ');

1603:
1604: IF (departure_id <> 0) THEN
1605: -- select non-ship lines from orders in departure
1606: Process_Buffer('n', ' AND EXISTS (SELECT LD1.LINE_DETAIL_ID ');
1607: Process_Buffer('n', ' FROM SO_LINES_ALL L1, ');
1608: Process_Buffer('n', ' SO_LINE_DETAILS LD1, ');
1609: Process_Buffer('n', ' WSH_DEPARTURES D1 ');
1610: Process_Buffer('n', ' WHERE LD1.LINE_ID = L1.LINE_ID ');
1611: Process_Buffer('n', ' AND L1.HEADER_ID = L.HEADER_ID ');

Line 1620: Process_Buffer('n', ' FROM SO_LINES_ALL L1, SO_LINE_DETAILS LD1 ');

1616:
1617: IF (delivery_id <> 0) THEN
1618: -- select non-ship lines from orders in delivery
1619: Process_Buffer('n', ' AND EXISTS (SELECT LD1.LINE_DETAIL_ID ');
1620: Process_Buffer('n', ' FROM SO_LINES_ALL L1, SO_LINE_DETAILS LD1 ');
1621: Process_Buffer('n', ' WHERE LD1.LINE_ID = L1.LINE_ID ');
1622: Process_Buffer('n', ' AND L1.HEADER_ID = L.HEADER_ID ');
1623: Process_Buffer('n', ' AND LD1.DELIVERY = :X_delivery_id) ' || ' ');
1624: END IF;

Line 1632: Process_Buffer('sreq',' UPDATE SO_LINES_ALL L ');

1628: Process_Buffer('n', ' H.HEADER_ID ASC ');
1629:
1630: ELSIF (p_sql_type = 'SET REQUEST') THEN
1631: sreq_SQL := '';
1632: Process_Buffer('sreq',' UPDATE SO_LINES_ALL L ');
1633: Process_Buffer('sreq',' SET L.REQUEST_ID = :X_request_id ');
1634: Process_Buffer('sreq',' WHERE L.LINE_ID IN ');
1635: Process_Buffer('sreq',' (SELECT L2.LINE_ID ');
1636: Process_Buffer('sreq',' FROM SO_HEADERS_ALL H, ');

Line 1637: Process_Buffer('sreq',' SO_LINES_ALL L2 ');

1633: Process_Buffer('sreq',' SET L.REQUEST_ID = :X_request_id ');
1634: Process_Buffer('sreq',' WHERE L.LINE_ID IN ');
1635: Process_Buffer('sreq',' (SELECT L2.LINE_ID ');
1636: Process_Buffer('sreq',' FROM SO_HEADERS_ALL H, ');
1637: Process_Buffer('sreq',' SO_LINES_ALL L2 ');
1638: Process_Buffer('sreq',' WHERE L2.LINE_ID = :X_sync_line_id ');
1639: Process_Buffer('sreq',' AND L2.HEADER_ID = H.HEADER_ID ');
1640: Process_Buffer('sreq',' AND (NVL(L2.DATE_REQUESTED_CURRENT, H.DATE_REQUESTED_CURRENT) >= ');
1641: Process_Buffer('sreq',' to_date(:X_from_request_date,''YYYY/MM/DD HH24:MI:SS'') OR ');

Line 1649: Process_Buffer('sreq',' SO_LINES_ALL L3 ');

1645: Process_Buffer('sreq',' :X_to_request_date IS NULL) ');
1646: Process_Buffer('sreq',' UNION ');
1647: Process_Buffer('sreq',' SELECT L3.LINE_ID ');
1648: Process_Buffer('sreq',' FROM SO_HEADERS_ALL H, ');
1649: Process_Buffer('sreq',' SO_LINES_ALL L3 ');
1650: Process_Buffer('sreq',' WHERE L3.PARENT_LINE_ID = :X_sync_line_id ');
1651: Process_Buffer('sreq',' AND L3.HEADER_ID = H.HEADER_ID ');
1652: Process_Buffer('sreq',' AND (NVL(L3.DATE_REQUESTED_CURRENT, H.DATE_REQUESTED_CURRENT) >= ');
1653: Process_Buffer('sreq',' to_date(:X_from_request_date,''YYYY/MM/DD HH24:MI:SS'') OR ');