APPS.INV_ITEM_CATEGORY_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 78: l_approval_status MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE;

74: l_control_level NUMBER;
75: p_master_org_id NUMBER;
76: l_request_id NUMBER;--2879647
77: l_hierarchy_enabled VARCHAR2(1);
78: l_approval_status MTL_SYSTEM_ITEMS_B.APPROVAL_STATUS%TYPE;
79: -- l_assign_exists BOOLEAN;
80: l_is_gpc_catalog VARCHAR2(1); -- Bug 8208540
81:
82: CURSOR org_item_exists_csr

Line 87: FROM mtl_system_items_b

83: ( p_inventory_item_id NUMBER
84: , p_organization_id NUMBER
85: ) IS
86: SELECT 'x',request_id, approval_status --2879647
87: FROM mtl_system_items_b
88: WHERE inventory_item_id = p_inventory_item_id
89: AND organization_id = p_organization_id;
90: --AND NVL(approval_status,'A') = 'A'; --Added for 11.5.10 PLM
91:

Line 441: FROM mtl_parameters p , mtl_system_items_b i

437: , SYSDATE
438: , FND_GLOBAL.user_id
439: , FND_GLOBAL.login_id
440: , FND_GLOBAL.conc_request_id
441: FROM mtl_parameters p , mtl_system_items_b i
442: WHERE p.master_organization_id = p_master_org_id
443: AND i.inventory_item_id = p_inventory_item_id
444: AND i.organization_id = p.organization_id
445: AND not exists

Line 591: gdsn_outbound_enabled_flag MTL_SYSTEM_ITEMS_B.GDSN_OUTBOUND_ENABLED_FLAG%TYPE;

587: FF11 VARCHAR2(1);
588: FF12 VARCHAR2(1); --Bug:6485437
589: FF21 VARCHAR2(1);
590: l_default_catalog_id MTL_DEFAULT_CATEGORY_SETS.CATEGORY_SET_ID%TYPE;
591: gdsn_outbound_enabled_flag MTL_SYSTEM_ITEMS_B.GDSN_OUTBOUND_ENABLED_FLAG%TYPE;
592:
593: inv_item_flagg VARCHAR2(1);
594: purch_item_flagg VARCHAR2(1);
595: int_order_flagg VARCHAR2(1);

Line 634: FROM mtl_system_items_b

630: CURSOR fetch_gdsn_flag(cp_inventory_item_id NUMBER,
631: cp_organization_id NUMBER)
632: IS
633: SELECT gdsn_outbound_enabled_flag
634: FROM mtl_system_items_b
635: WHERE inventory_item_id = cp_inventory_item_id
636: AND organization_id = cp_organization_id;
637:
638: BEGIN