58: psp.DEFAULT_RATE_TYPE,
59: 30),10)
60: FROM cst_item_costs_for_gl_view cic,
61: mtl_parameters mp,
62: po_system_parameters psp
63: WHERE cic.inventory_item_id = p_item_id
64: AND cic.organization_id = mp.cost_organization_id
65: AND cic.inventory_asset_flag = 1
66: AND mp.organization_id= p_source_organization_id;
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
83: AND ood.organization_id = p_source_organization_id
84: AND msi.organization_id = ood.organization_id
85: AND glsob.set_of_books_id = ood.set_of_books_id;
687:
688: -- Get Default Line Type
689: CURSOR line_type_cur (p_org_id NUMBER) IS
690: SELECT line_type_id
691: FROM PO_SYSTEM_PARAMETERS
692: WHERE org_id = p_org_id;
693:
694: -- Get Item Description for a given Item ID
695: -- For the purpose of creating Approve Internal Requisition