APPS.PO_SUBINVENTORIES_S dependencies on MTL_SYSTEM_ITEMS

Line 86: FROM MTL_SYSTEM_ITEMS

82: /* varify if the given item has restricted sub control */
83: x_progress := '020';
84: SELECT RESTRICT_SUBINVENTORIES_CODE
85: INTO x_restrict_sub
86: FROM MTL_SYSTEM_ITEMS
87: WHERE INVENTORY_ITEM_ID = x_item_id
88: AND ORGANIZATION_ID = x_organization_id;
89:
90: -- dbms_output.put_line ('val_subinventory : x_restrict_sub : ' ||

Line 182: FROM MTL_SYSTEM_ITEMS

178: /* varify if the given item has restricted loc control */
179: x_progress := '020';
180: SELECT RESTRICT_LOCATORS_CODE
181: INTO x_restrict_loc
182: FROM MTL_SYSTEM_ITEMS
183: WHERE INVENTORY_ITEM_ID = x_item_id
184: AND ORGANIZATION_ID = x_organization_id;
185: /* check mfg_lookups for lookup_type = 'RESTRICT_LOCATORS_CODE' */
186:

Line 268: --FROM mtl_system_items

264: */
265: /* always check item restrict locator control */
266: --SELECT restrict_locators_code, location_control_code
267: --INTO x_restrict_locator, x_item_locator_control
268: --FROM mtl_system_items
269: --WHERE organization_id = x_organization_id
270: --AND inventory_item_id = x_item_id;
271:
272: /* if an item under restrict locator control, set control = 2 */

Line 303: ** from mtl_system_items as well

299: END IF;
300:
301: /*
302: ** bug 724495, get the restrict_locators_code
303: ** from mtl_system_items as well
304: */
305:
306: IF x_locator = 5 THEN
307: x_progress := '020';

Line 310: FROM mtl_system_items

306: IF x_locator = 5 THEN
307: x_progress := '020';
308: SELECT restrict_locators_code, location_control_code
309: INTO x_restrict_locator, x_locator
310: FROM mtl_system_items
311: WHERE organization_id = x_organization_id
312: AND inventory_item_id = x_item_id;
313: END IF;
314:

Line 382: FROM mtl_system_items

378: IF x_locator = 5 THEN
379: x_progress := '020';
380: SELECT location_control_code
381: INTO x_locator
382: FROM mtl_system_items
383: WHERE organization_id = x_organization_id
384: AND inventory_item_id = x_item_id;
385: END IF;
386:

Line 514: x_asset_flag mtl_system_items.inventory_asset_flag%type;

510: x_item_id IN NUMBER,
511: x_allow_expense_source OUT NOCOPY VARCHAR2
512: ) IS
513:
514: x_asset_flag mtl_system_items.inventory_asset_flag%type;
515: x_intransit_type mtl_interorg_parameters.intransit_type%type;
516: x_dest_sub_name mtl_item_sub_defaults.subinventory_code%type;
517: x_sub_type mtl_secondary_inventories.asset_inventory%type;
518: x_progress VARCHAR2(3) := NULL;

Line 529: FROM mtl_system_items

525: /* get the asset flag for the item in the destination org */
526:
527: SELECT inventory_asset_flag
528: INTO x_asset_flag
529: FROM mtl_system_items
530: WHERE organization_id = x_destination_organization_id
531: AND inventory_item_id = x_item_id;
532:
533: -- dbms_output.put_line('Asset flag = ' || x_asset_flag);

Line 678: x_restrict_sub mtl_system_items.restrict_subinventories_code%type;

674: RETURN BOOLEAN IS
675:
676: x_progress VARCHAR2(3) := '';
677: x_count NUMBER := 0;
678: x_restrict_sub mtl_system_items.restrict_subinventories_code%type;
679: x_intransit_type mtl_interorg_parameters.intransit_type%type;
680: x_allow_expense_source VARCHAR2(1) := '';
681:
682: BEGIN

Line 732: FROM mtl_system_items msi

728: x_progress := '020';
729:
730: SELECT msi.restrict_subinventories_code
731: INTO x_restrict_sub
732: FROM mtl_system_items msi
733: WHERE msi.inventory_item_id = x_item_id
734: AND organization_id = x_src_org_id;
735:
736: