DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on MTL_SYSTEM_ITEMS_B

Line 1175: FROM mtl_system_items_b

1171: -- it is assumed that the calling procedure will always pass the Item ID
1172: -- so that Item Description can be derived.
1173: CURSOR item_Desc_cur(p_item_id NUMBER, p_orgn_id NUMBER) IS
1174: SELECT description
1175: FROM mtl_system_items_b
1176: WHERE inventory_item_id = p_item_id
1177: AND organization_id = p_orgn_id;
1178:
1179: CURSOR rs_loc_exists_cur(p_inv_loc_id NUMBER, p_resource_id NUMBER, p_resource_type VARCHAR2) IS