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 STANDARD

Line 1040: Process_Buffer('u', ' NVL(TO_CHAR(L.STANDARD_COMPONENT_FREEZE_DATE,''YYYY/MM/DD HH24:MI''),''''), ');

1036: Process_Buffer('u', ' NVL(L.SHIPMENT_SCHEDULE_LINE_ID,0), ');
1037: Process_Buffer('u', ' L.UNIT_CODE, ');
1038: Process_Buffer('u', ' L.LINE_TYPE_CODE, ');
1039: Process_Buffer('u', ' L.COMPONENT_CODE, ');
1040: Process_Buffer('u', ' NVL(TO_CHAR(L.STANDARD_COMPONENT_FREEZE_DATE,''YYYY/MM/DD HH24:MI''),''''), ');
1041: Process_Buffer('u', ' H.ORDER_NUMBER, ');
1042: Process_Buffer('u', ' H.ORDER_TYPE_ID, ');
1043: Process_Buffer('u', ' H.CUSTOMER_ID, ');
1044: Process_Buffer('u', ' H.INVOICE_TO_SITE_USE_ID, ');

Line 1076: Process_Buffer('u', ' (''KIT'',''MODEL'',''CLASS'',''STANDARD'') ');

1072: Process_Buffer('u', ' AND LD.DELIVERY_ID = DL.DELIVERY_ID (+) ');
1073: Process_Buffer('u', ' AND L.LINE_TYPE_CODE IN (''REGULAR'',''DETAIL'') ');
1074: Process_Buffer('u', ' AND L.SOURCE_TYPE_CODE = ''INTERNAL'' ');
1075: Process_Buffer('u', ' AND L.ITEM_TYPE_CODE IN ');
1076: Process_Buffer('u', ' (''KIT'',''MODEL'',''CLASS'',''STANDARD'') ');
1077: Process_Buffer('u', ' AND NOT ((L.ITEM_TYPE_CODE = ''STANDARD'') AND ');
1078: Process_Buffer('u', ' (NVL(L.PARENT_LINE_ID,-9) = -9) AND ');
1079: Process_Buffer('u', ' (NVL(L.ATO_FLAG,''N'') = ''N'') AND ');
1080: Process_Buffer('u', ' (LD.SHIPPABLE_FLAG || '''' = ''N'')) ');

Line 1077: Process_Buffer('u', ' AND NOT ((L.ITEM_TYPE_CODE = ''STANDARD'') AND ');

1073: Process_Buffer('u', ' AND L.LINE_TYPE_CODE IN (''REGULAR'',''DETAIL'') ');
1074: Process_Buffer('u', ' AND L.SOURCE_TYPE_CODE = ''INTERNAL'' ');
1075: Process_Buffer('u', ' AND L.ITEM_TYPE_CODE IN ');
1076: Process_Buffer('u', ' (''KIT'',''MODEL'',''CLASS'',''STANDARD'') ');
1077: Process_Buffer('u', ' AND NOT ((L.ITEM_TYPE_CODE = ''STANDARD'') AND ');
1078: Process_Buffer('u', ' (NVL(L.PARENT_LINE_ID,-9) = -9) AND ');
1079: Process_Buffer('u', ' (NVL(L.ATO_FLAG,''N'') = ''N'') AND ');
1080: Process_Buffer('u', ' (LD.SHIPPABLE_FLAG || '''' = ''N'')) ');
1081: Process_Buffer('u', ' AND NVL(L.CANCELLED_QUANTITY,0) < L.ORDERED_QUANTITY ');

Line 1088: Process_Buffer('u', ' AND ((L.STANDARD_COMPONENT_FREEZE_DATE IS NOT NULL ');

1084: Process_Buffer('u', ' AND H.OPEN_FLAG || '''' = ''Y'' ');
1085: Process_Buffer('u', ' AND LD.RELEASED_FLAG || '''' = ''N'' ');
1086: Process_Buffer('u', ' AND LD.SCHEDULE_DATE IS NOT NULL ');
1087:
1088: Process_Buffer('u', ' AND ((L.STANDARD_COMPONENT_FREEZE_DATE IS NOT NULL ');
1089: Process_Buffer('u', ' AND DECODE(L.ATO_FLAG,''N'', ');
1090: Process_Buffer('u', ' LD.SHIPPABLE_FLAG,''Y'') || '''' = ''Y'') ');
1091: Process_Buffer('u', ' OR ');
1092: Process_Buffer('u', ' (L.STANDARD_COMPONENT_FREEZE_DATE IS NULL ');

Line 1092: Process_Buffer('u', ' (L.STANDARD_COMPONENT_FREEZE_DATE IS NULL ');

1088: Process_Buffer('u', ' AND ((L.STANDARD_COMPONENT_FREEZE_DATE IS NOT NULL ');
1089: Process_Buffer('u', ' AND DECODE(L.ATO_FLAG,''N'', ');
1090: Process_Buffer('u', ' LD.SHIPPABLE_FLAG,''Y'') || '''' = ''Y'') ');
1091: Process_Buffer('u', ' OR ');
1092: Process_Buffer('u', ' (L.STANDARD_COMPONENT_FREEZE_DATE IS NULL ');
1093: Process_Buffer('u', ' AND (LD.INCLUDED_ITEM_FLAG || '''' = ''N'' ');
1094: Process_Buffer('u', ' OR LD.SHIPPABLE_FLAG || '''' = ''Y''))) ');
1095:
1096: IF (header_id <> 0 OR departure_id <> 0 OR order_line_id <> 0) THEN

Line 1242: Process_Buffer('b', ' NVL(TO_CHAR(L.STANDARD_COMPONENT_FREEZE_DATE,''YYYY/MM/DD HH24:MI''),''''), ');

1238: Process_Buffer('b', ' NVL(L.SHIPMENT_SCHEDULE_LINE_ID,0), ');
1239: Process_Buffer('b', ' PL.UNIT_CODE, ');
1240: Process_Buffer('b', ' L.LINE_TYPE_CODE, ');
1241: Process_Buffer('b', ' L.COMPONENT_CODE, ');
1242: Process_Buffer('b', ' NVL(TO_CHAR(L.STANDARD_COMPONENT_FREEZE_DATE,''YYYY/MM/DD HH24:MI''),''''), ');
1243: Process_Buffer('b', ' H.ORDER_NUMBER, ');
1244: Process_Buffer('b', ' H.ORDER_TYPE_ID, ');
1245: Process_Buffer('b', ' H.CUSTOMER_ID, ');
1246: Process_Buffer('b', ' H.INVOICE_TO_SITE_USE_ID, ');

Line 1510: -- This statement selects service and non-shippable standard lines

1506: Process_Buffer('s', ' OR (NVL(LD.DEP_PLAN_REQUIRED_FLAG,''N'') = ''N'')) ');
1507:
1508: ELSIF (p_sql_type = 'NON_SHIPPABLE') THEN
1509: --
1510: -- This statement selects service and non-shippable standard lines
1511: --
1512:
1513: non_ship_SQL := '';
1514: Process_Buffer('n', ' SELECT ');

Line 1530: Process_Buffer('n', ' OR (L.ITEM_TYPE_CODE = ''STANDARD'' ');

1526: Process_Buffer('n', ' AND L.OPEN_FLAG || '''' = ''Y'' ');
1527: Process_Buffer('n', ' AND H.OPEN_FLAG || '''' = ''Y'' ');
1528: Process_Buffer('n', ' AND NVL(LD.RELEASED_FLAG, ''N'') = ''N'' ');
1529: Process_Buffer('n', ' AND (L.ITEM_TYPE_CODE = ''SERVICE'' ');
1530: Process_Buffer('n', ' OR (L.ITEM_TYPE_CODE = ''STANDARD'' ');
1531: Process_Buffer('n', ' AND NOT EXISTS ');
1532: Process_Buffer('n', ' ( SELECT XX.LINE_ID FROM ');
1533: Process_Buffer('n', ' SO_LINE_DETAILS XX ');
1534: Process_Buffer('n', ' WHERE ');