APPS.CSP_SCH_INT_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1935: from mtl_system_items_b_kfv

1931: and lookup_code = c_errro_code;
1932:
1933: CURSOR get_item_segments(c_item_id number,c_organization_id number) IS
1934: select distinct(CONCATENATED_SEGMENTS)
1935: from mtl_system_items_b_kfv
1936: where inventory_item_id = c_item_id
1937: and organization_id = cs_std.get_item_valdn_orgzn_id;
1938:
1939: CURSOR check_buy_from(c_item_id number,c_assignment_id number, c_organization_id number)

Line 3756: FROM MTL_SYSTEM_ITEMS_B

3752: and sourcing_level not in (2,9));
3753:
3754: CURSOR primary_uom_code(item_id NUMBER,org_id NUMBER) IS
3755: SELECT PRIMARY_UOM_CODE
3756: FROM MTL_SYSTEM_ITEMS_B
3757: WHERE INVENTORY_ITEM_ID = item_id
3758: AND organization_id = org_id;
3759:
3760: CURSOR substitutes(item_id NUMBER,org_id NUMBER) IS

Line 4709: FROM MTL_SYSTEM_ITEMS_B

4705:
4706: -- bug # 4618899
4707: CURSOR primary_uom_code(item_id NUMBER,org_id NUMBER) IS
4708: SELECT PRIMARY_UOM_CODE
4709: FROM MTL_SYSTEM_ITEMS_B
4710: WHERE INVENTORY_ITEM_ID = item_id
4711: AND organization_id = org_id;
4712: l_primary_uom varchar2(500);
4713:

Line 4856: FROM MTL_SYSTEM_ITEMS_B

4852:
4853: -- bug # 4618899
4854: CURSOR primary_uom_code(item_id NUMBER,org_id NUMBER) IS
4855: SELECT PRIMARY_UOM_CODE
4856: FROM MTL_SYSTEM_ITEMS_B
4857: WHERE INVENTORY_ITEM_ID = item_id
4858: AND organization_id = org_id;
4859: l_primary_uom varchar2(500);
4860:

Line 5216: FROM MTL_SYSTEM_ITEMS_B

5212: l_substitute_item NUMBER;
5213:
5214: CURSOR primary_uom_code(item_id NUMBER,org_id NUMBER) IS
5215: SELECT PRIMARY_UOM_CODE
5216: FROM MTL_SYSTEM_ITEMS_B
5217: WHERE INVENTORY_ITEM_ID = item_id
5218: AND organization_id = org_id;
5219:
5220: CURSOR substitutes(item_id NUMBER,org_id NUMBER) IS