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:
81: CURSOR org_item_exists_csr
82: ( p_inventory_item_id NUMBER

Line 86: FROM mtl_system_items_b

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

Line 431: FROM mtl_parameters p , mtl_system_items_b i

427: , SYSDATE
428: , FND_GLOBAL.user_id
429: , FND_GLOBAL.login_id
430: , FND_GLOBAL.conc_request_id
431: FROM mtl_parameters p , mtl_system_items_b i
432: WHERE p.master_organization_id = p_master_org_id
433: AND i.inventory_item_id = p_inventory_item_id
434: AND i.organization_id = p.organization_id
435: AND not exists

Line 581: gdsn_outbound_enabled_flag MTL_SYSTEM_ITEMS_B.GDSN_OUTBOUND_ENABLED_FLAG%TYPE;

577: FF11 VARCHAR2(1);
578: FF12 VARCHAR2(1); --Bug:6485437
579: FF21 VARCHAR2(1);
580: l_default_catalog_id MTL_DEFAULT_CATEGORY_SETS.CATEGORY_SET_ID%TYPE;
581: gdsn_outbound_enabled_flag MTL_SYSTEM_ITEMS_B.GDSN_OUTBOUND_ENABLED_FLAG%TYPE;
582:
583: inv_item_flagg VARCHAR2(1);
584: purch_item_flagg VARCHAR2(1);
585: int_order_flagg VARCHAR2(1);

Line 624: FROM mtl_system_items_b

620: CURSOR fetch_gdsn_flag(cp_inventory_item_id NUMBER,
621: cp_organization_id NUMBER)
622: IS
623: SELECT gdsn_outbound_enabled_flag
624: FROM mtl_system_items_b
625: WHERE inventory_item_id = cp_inventory_item_id
626: AND organization_id = cp_organization_id;
627:
628: BEGIN