DBA Data[Home] [Help]

APPS.CSP_PLANNED_ORDERS dependencies on MTL_SYSTEM_ITEMS_B

Line 86: FROM mtl_system_items_b

82:
83: CURSOR uom_code_cur(t_organization_id NUMBER,
84: t_item_id NUMBER) IS
85: SELECT primary_uom_code
86: FROM mtl_system_items_b
87: WHERE organization_id = t_organization_id
88: AND inventory_item_id = t_item_id;
89:
90: CURSOR C_supplier (p_organization_id NUMBER,l_supplied_item_id NUMBER)

Line 248: FROM mtl_system_items_b

244:
245: Begin
246: SELECT repair_program
247: INTO l_repair_program
248: FROM mtl_system_items_b
249: WHERE organization_id = l_repair_supplier_org_id
250: AND inventory_item_id = p_inventory_item_id;
251: Exception
252: When no_data_found then