DBA Data[Home] [Help]

APPS.PO_CREATE_REQUISITION_SV dependencies on PO_SYSTEM_PARAMETERS

Line 62: po_system_parameters psp

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;

Line 81: po_system_parameters psp

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;

Line 693: FROM PO_SYSTEM_PARAMETERS

689:
690: -- Get Default Line Type
691: CURSOR line_type_cur (p_org_id NUMBER) IS
692: SELECT line_type_id
693: FROM PO_SYSTEM_PARAMETERS
694: WHERE org_id = p_org_id;
695:
696: -- Get Item Description for a given Item ID
697: -- For the purpose of creating Approve Internal Requisition