APPS.PO_CREATE_REQUISITION_SV dependencies on MTL_SYSTEM_ITEMS

Line 78: FROM mtl_system_items msi,

74: glsob.currency_code,
75: trunc(sysdate),
76: psp.DEFAULT_RATE_TYPE,
77: 30),10)
78: FROM mtl_system_items msi,
79: gl_sets_of_books glsob,
80: org_organization_definitions ood,
81: po_system_parameters psp
82: WHERE msi.inventory_item_id = p_item_id

Line 241: FROM mtl_system_items

237: RETURN VARCHAR2 IS
238:
239: CURSOR item_type_cur IS
240: SELECT inventory_asset_flag
241: FROM mtl_system_items
242: WHERE organization_id = p_destination_organization_id
243: AND inventory_item_id = p_item_id;
244:
245: l_item_type VARCHAR2(10) := 'X';

Line 336: FROM mtl_system_items

332: BEGIN
333: d_progress := 70;
334: SELECT expense_account
335: INTO l_charge_account
336: FROM mtl_system_items
337: WHERE organization_id = p_destination_organization_id
338: AND inventory_item_id = p_item_id;
339: EXCEPTION
340: WHEN OTHERS THEN

Line 700: FROM mtl_system_items_b

696: -- it is assumed that the calling procedure will always pass the Item ID
697: -- so that Item Description can be derived.
698: CURSOR item_desc_cur(p_item_id NUMBER, p_orgn_id NUMBER) IS
699: SELECT description
700: FROM mtl_system_items_b
701: WHERE inventory_item_id = p_item_id
702: AND organization_id = p_orgn_id;
703:
704: -- Get Item Category ID

Line 749: FROM mtl_system_items msi,

745: -- from MTL_PARAMETERS for the Item and the Destination Organization
746: CURSOR budget_account_cur (p_destination_organization_id NUMBER,
747: p_item_id NUMBER) IS
748: SELECT nvl (msi.encumbrance_account,mp.encumbrance_account)
749: FROM mtl_system_items msi,
750: mtl_parameters mp
751: WHERE msi.inventory_item_id = p_item_id
752: AND msi.organization_id = p_destination_organization_id
753: AND mp.organization_id = msi.organization_id;

Line 767: FROM mtl_system_items

763: -- Get Charge Account for the Item and Organization
764: CURSOR charge_account_cur (p_destination_organization_id NUMBER,
765: p_item_id NUMBER) IS
766: SELECT NVL(expense_account,-1)
767: FROM mtl_system_items
768: WHERE inventory_item_id = p_item_id
769: AND organization_id = p_destination_organization_id;
770:
771: -- Get Unit_of_Measure from MTL_UNIT_OF_MEASURES, since OM passes