APPS.CSP_PARTS_ORDER dependencies on MTL_SYSTEM_ITEMS

Line 60: FROM mtl_system_items msi,

56: glsob.currency_code,
57: trunc(sysdate),
58: psp.DEFAULT_RATE_TYPE,
59: 30),10)
60: FROM mtl_system_items msi,
61: gl_sets_of_books glsob,
62: hr_organization_information hoi,
63: po_system_parameters psp
64: WHERE msi.inventory_item_id = p_item_id

Line 200: FROM mtl_system_items

196: RETURN VARCHAR2 IS
197:
198: CURSOR item_type_cur IS
199: SELECT inventory_asset_flag
200: FROM mtl_system_items
201: WHERE organization_id = p_destination_organization_id
202: AND inventory_item_id = p_item_id;
203:
204: l_item_type VARCHAR2(10) := 'X';

Line 269: FROM mtl_system_items

265: IF (l_charge_account IS NULL) THEN
266: BEGIN
267: SELECT expense_account
268: INTO l_charge_account
269: FROM mtl_system_items
270: WHERE organization_id = p_destination_organization_id
271: and inventory_item_id = p_item_id;
272: EXCEPTION
273: WHEN OTHERS THEN

Line 1110: FROM mtl_system_items msi,

1106: -- from MTL_PARAMETERS for the Item and the Destination Organization
1107: CURSOR budget_account_cur (p_destination_organization_id NUMBER,
1108: p_item_id NUMBER) IS
1109: SELECT nvl (msi.encumbrance_account,mp.encumbrance_account)
1110: FROM mtl_system_items msi,
1111: mtl_parameters mp
1112: WHERE msi.inventory_item_id = p_item_id
1113: AND msi.organization_id = p_destination_organization_id
1114: AND mp.organization_id = msi.organization_id;

Line 1128: FROM mtl_system_items

1124: -- Get Charge Account for the Item and Organization
1125: CURSOR charge_account_cur (p_destination_organization_id NUMBER,
1126: p_item_id NUMBER) IS
1127: SELECT NVL(expense_account,-1)
1128: FROM mtl_system_items
1129: WHERE inventory_item_id = p_item_id
1130: AND organization_id = p_destination_organization_id;
1131:
1132: -- Get Unit_of_Measure from MTL_UNIT_OF_MEASURES, since OM passes

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