APPS.CSP_SCH_INT_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1274: mtl_system_items_b msib

1270: from csp_available_parts_temp capt,
1271: org_organization_definitions ood,
1272: csp_requirement_lines crl,
1273: csp_requirement_headers crh,
1274: mtl_system_items_b msib
1275: where ood.organization_id = capt.organization_id
1276: and crl.requirement_header_id = crh.requirement_header_id
1277: and crl.inventory_item_id = capt.required_item_id
1278: and msib.organization_id = capt.organization_id

Line 4175: from mtl_system_items_b_kfv

4171: and lookup_code = c_errro_code;
4172:
4173: CURSOR get_item_segments(c_item_id number,c_organization_id number) IS
4174: select distinct(CONCATENATED_SEGMENTS)
4175: from mtl_system_items_b_kfv
4176: where inventory_item_id = c_item_id
4177: and organization_id = cs_std.get_item_valdn_orgzn_id;
4178:
4179: CURSOR check_buy_from(c_item_id number,c_assignment_id number, c_organization_id number)

Line 6196: FROM MTL_SYSTEM_ITEMS_B

6192:
6193: CURSOR primary_uom_code(item_id NUMBER,org_id NUMBER)
6194: IS
6195: SELECT PRIMARY_UOM_CODE
6196: FROM MTL_SYSTEM_ITEMS_B
6197: WHERE INVENTORY_ITEM_ID = item_id
6198: AND organization_id = org_id;
6199: CURSOR substitutes(item_id NUMBER,org_id NUMBER)
6200: IS

Line 7251: FROM MTL_SYSTEM_ITEMS_B

7247:
7248: -- bug # 4618899
7249: CURSOR primary_uom_code(item_id NUMBER,org_id NUMBER) IS
7250: SELECT PRIMARY_UOM_CODE
7251: FROM MTL_SYSTEM_ITEMS_B
7252: WHERE INVENTORY_ITEM_ID = item_id
7253: AND organization_id = org_id;
7254: l_primary_uom varchar2(500);
7255:

Line 7398: FROM MTL_SYSTEM_ITEMS_B

7394:
7395: -- bug # 4618899
7396: CURSOR primary_uom_code(item_id NUMBER,org_id NUMBER) IS
7397: SELECT PRIMARY_UOM_CODE
7398: FROM MTL_SYSTEM_ITEMS_B
7399: WHERE INVENTORY_ITEM_ID = item_id
7400: AND organization_id = org_id;
7401: l_primary_uom varchar2(500);
7402:

Line 7758: FROM MTL_SYSTEM_ITEMS_B

7754: l_substitute_item NUMBER;
7755:
7756: CURSOR primary_uom_code(item_id NUMBER,org_id NUMBER) IS
7757: SELECT PRIMARY_UOM_CODE
7758: FROM MTL_SYSTEM_ITEMS_B
7759: WHERE INVENTORY_ITEM_ID = item_id
7760: AND organization_id = org_id;
7761:
7762: CURSOR substitutes(item_id NUMBER,org_id NUMBER) IS