DBA Data[Home] [Help]

APPS.WSH_WSHRDOPN_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 36: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

32: FROM
33: WSH_LOOKUPS
34: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
35: AND LOOKUP_CODE = P_ITEM_DISPLAY;
36: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
37: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;
38: CURSOR GET_ITEM_NAME IS
39: SELECT
40: CONCATENATED_SEGMENTS

Line 37: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;

33: WSH_LOOKUPS
34: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
35: AND LOOKUP_CODE = P_ITEM_DISPLAY;
36: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
37: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;
38: CURSOR GET_ITEM_NAME IS
39: SELECT
40: CONCATENATED_SEGMENTS
41: FROM

Line 42: MTL_SYSTEM_ITEMS_KFV

38: CURSOR GET_ITEM_NAME IS
39: SELECT
40: CONCATENATED_SEGMENTS
41: FROM
42: MTL_SYSTEM_ITEMS_KFV
43: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
44: AND INVENTORY_ITEM_ID = V_ITEM_ID;
45: V_ITEM_SELECT VARCHAR2(90);
46: V_ITEM_FROM VARCHAR2(150);

Line 189: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

185: FROM
186: WSH_LOOKUPS
187: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
188: AND LOOKUP_CODE = P_ITEM_DISPLAY;
189: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
190: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;
191: CURSOR GET_ITEM_NAME IS
192: SELECT
193: CONCATENATED_SEGMENTS

Line 190: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;

186: WSH_LOOKUPS
187: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
188: AND LOOKUP_CODE = P_ITEM_DISPLAY;
189: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
190: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;
191: CURSOR GET_ITEM_NAME IS
192: SELECT
193: CONCATENATED_SEGMENTS
194: FROM

Line 195: MTL_SYSTEM_ITEMS_KFV

191: CURSOR GET_ITEM_NAME IS
192: SELECT
193: CONCATENATED_SEGMENTS
194: FROM
195: MTL_SYSTEM_ITEMS_KFV
196: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
197: AND INVENTORY_ITEM_ID = V_ITEM_ID;
198: V_ITEM_SELECT VARCHAR2(90);
199: V_ITEM_FROM VARCHAR2(150);

Line 286: V_ITEM_FROM := 'from wsh_new_deliveries wnd2, wsh_delivery_assignments_v wda2, wsh_delivery_details wdd2, mtl_system_items_kfv msik2 ';

282: IF (P_ITEM_ID IS NULL) THEN
283: NULL;
284: ELSE
285: V_ITEM_SELECT := ' and (wnd.name, wnd.delivery_id) IN (select wnd2.name, wnd2.delivery_id ';
286: V_ITEM_FROM := 'from wsh_new_deliveries wnd2, wsh_delivery_assignments_v wda2, wsh_delivery_details wdd2, mtl_system_items_kfv msik2 ';
287: V_ITEM_WHERE := 'where wnd2.delivery_id = wda2.delivery_id and wda2.delivery_detail_id = wdd2.delivery_detail_id and
288: wnd2.organization_id = msik2.organization_id and wdd2.inventory_item_id = msik2.inventory_item_id and ';
289: V_ITEM_QUALIFY := ' msik2.concatenated_segments = ' || '''' || V_CONCAT || '''' || ')';
290: V_ITEM_TOTAL := V_ITEM_SELECT || V_ITEM_FROM || V_ITEM_WHERE || V_ITEM_QUALIFY;