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 702: FROM mtl_system_items_b

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

Line 751: FROM mtl_system_items msi,

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

Line 769: FROM mtl_system_items

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