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 1232: FROM mtl_system_items msi,

1228: -- from MTL_PARAMETERS for the Item and the Destination Organization
1229: CURSOR budget_account_cur (p_destination_organization_id NUMBER,
1230: p_item_id NUMBER) IS
1231: SELECT nvl (msi.encumbrance_account,mp.encumbrance_account)
1232: FROM mtl_system_items msi,
1233: mtl_parameters mp
1234: WHERE msi.inventory_item_id = p_item_id
1235: AND msi.organization_id = p_destination_organization_id
1236: AND mp.organization_id = msi.organization_id;

Line 1250: FROM mtl_system_items

1246: -- Get Charge Account for the Item and Organization
1247: CURSOR charge_account_cur (p_destination_organization_id NUMBER,
1248: p_item_id NUMBER) IS
1249: SELECT NVL(expense_account,-1)
1250: FROM mtl_system_items
1251: WHERE inventory_item_id = p_item_id
1252: AND organization_id = p_destination_organization_id;
1253:
1254: -- Get Unit_of_Measure from MTL_UNIT_OF_MEASURES, since OM passes

Line 1442: FROM mtl_system_items_b

1438: -- it is assumed that the calling procedure will always pass the Item ID
1439: -- so that Item Description can be derived.
1440: CURSOR item_Desc_cur(p_item_id NUMBER, p_orgn_id NUMBER) IS
1441: SELECT description
1442: FROM mtl_system_items_b
1443: WHERE inventory_item_id = p_item_id
1444: AND organization_id = p_orgn_id;
1445: -- Bug 14494663 - Not required as in case of special ship address as we cannot create address
1446: /* CURSOR rs_loc_exists_cur(p_inv_loc_id NUMBER, p_resource_id NUMBER, p_resource_type VARCHAR2) IS

Line 3106: FROM mtl_system_items_kfv

3102:
3103: if l_line_tbl(i).source_organization_id is not null then
3104: SELECT concatenated_segments
3105: INTO l_line_tbl(i).item_description -- taking dummy variable as we are going to throw an error only
3106: FROM mtl_system_items_kfv
3107: WHERE organization_id = l_line_tbl(i).source_organization_id
3108: and inventory_item_id = l_line_tbl(i).inventory_item_id;
3109:
3110: select organization_code

Line 4568: and Planner_code = ( Select Planner_code from mtl_system_items_b

4564: l_autosource_flag := 'N';
4565: Begin
4566: Select employee_id into l_planner_employee_id From MTL_PLANNERS
4567: Where Organization_id = l_header_rec.dest_organization_id
4568: and Planner_code = ( Select Planner_code from mtl_system_items_b
4569: where inventory_item_id = l_line_tbl(i).inventory_item_id and organization_id =
4570: l_header_rec.dest_organization_id )
4571: and nvl(DISABLE_DATE,SYSDATE+1) > SYSDATE;
4572: Exception