APPS.WSH_WSHRDOPN_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 44: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

40: FROM
41: WSH_LOOKUPS
42: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
43: AND LOOKUP_CODE = P_ITEM_DISPLAY;
44: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
45: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;
46: CURSOR GET_ITEM_NAME IS
47: SELECT
48: CONCATENATED_SEGMENTS

Line 45: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;

41: WSH_LOOKUPS
42: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
43: AND LOOKUP_CODE = P_ITEM_DISPLAY;
44: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
45: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;
46: CURSOR GET_ITEM_NAME IS
47: SELECT
48: CONCATENATED_SEGMENTS
49: FROM

Line 50: MTL_SYSTEM_ITEMS_KFV

46: CURSOR GET_ITEM_NAME IS
47: SELECT
48: CONCATENATED_SEGMENTS
49: FROM
50: MTL_SYSTEM_ITEMS_KFV
51: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
52: AND INVENTORY_ITEM_ID = V_ITEM_ID;
53: V_ITEM_SELECT VARCHAR2(90);
54: V_ITEM_FROM VARCHAR2(150);

Line 216: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

212: FROM
213: WSH_LOOKUPS
214: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
215: AND LOOKUP_CODE = P_ITEM_DISPLAY;
216: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
217: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;
218: CURSOR GET_ITEM_NAME IS
219: SELECT
220: CONCATENATED_SEGMENTS

Line 217: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;

213: WSH_LOOKUPS
214: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
215: AND LOOKUP_CODE = P_ITEM_DISPLAY;
216: V_CONCAT MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
217: V_ITEM_ID MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE;
218: CURSOR GET_ITEM_NAME IS
219: SELECT
220: CONCATENATED_SEGMENTS
221: FROM

Line 222: MTL_SYSTEM_ITEMS_KFV

218: CURSOR GET_ITEM_NAME IS
219: SELECT
220: CONCATENATED_SEGMENTS
221: FROM
222: MTL_SYSTEM_ITEMS_KFV
223: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
224: AND INVENTORY_ITEM_ID = V_ITEM_ID;
225: V_ITEM_SELECT VARCHAR2(90);
226: V_ITEM_FROM VARCHAR2(150);

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

322: IF (P_ITEM_ID IS NULL) THEN
323: NULL;
324: ELSE
325: V_ITEM_SELECT := ' and (wnd.name, wnd.delivery_id) IN (select wnd2.name, wnd2.delivery_id ';
326: V_ITEM_FROM := 'from wsh_new_deliveries wnd2, wsh_delivery_assignments_v wda2, wsh_delivery_details wdd2, mtl_system_items_kfv msik2 ';
327: V_ITEM_WHERE := 'where wnd2.delivery_id = wda2.delivery_id and wda2.delivery_detail_id = wdd2.delivery_detail_id and
328: wnd2.organization_id = msik2.organization_id and wdd2.inventory_item_id = msik2.inventory_item_id and ';
329: V_ITEM_QUALIFY := ' msik2.concatenated_segments = ' || '''' || V_CONCAT || '''' || ')';
330: V_ITEM_TOTAL := V_ITEM_SELECT || V_ITEM_FROM || V_ITEM_WHERE || V_ITEM_QUALIFY;