DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on PO_SYSTEM_PARAMETERS

Line 63: po_system_parameters psp

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
65: AND hoi.organization_id = p_source_organization_id
66: AND hoi.org_information_context = 'Accounting Information'
67: AND msi.organization_id = hoi.organization_id

Line 79: po_system_parameters psp

75: psp.DEFAULT_RATE_TYPE,
76: 30),10)
77: FROM gl_sets_of_books glsob,
78: hr_organization_information hoi,
79: po_system_parameters psp
80: WHERE hoi.organization_id = p_source_organization_id
81: AND HOI.ORG_INFORMATION_CONTEXT = 'Accounting Information'
82: AND glsob.set_of_books_id = hoi.org_information1;
83:

Line 1146: FROM PO_SYSTEM_PARAMETERS_ALL psp,

1142: SELECT psp.line_type_id,
1143: plt.order_type_lookup_code,
1144: plt.purchase_basis,
1145: plt.matching_basis
1146: FROM PO_SYSTEM_PARAMETERS_ALL psp,
1147: PO_LINE_TYPES plt
1148: WHERE psp.org_id = l_org_id
1149: AND plt.line_type_id = psp.line_type_id;
1150:

Line 1743: FROM PO_SYSTEM_PARAMETERS_ALL

1739: BEGIN
1740: IF (l_org_id <> l_source_operating_unit) THEN
1741: SELECT ORDER_TYPE_ID
1742: INTO l_header_rec.order_type_id
1743: FROM PO_SYSTEM_PARAMETERS_ALL
1744: WHERE nvl(ORG_ID,-1) = l_source_operating_unit;
1745: -- bug # 7644078
1746: -- Here we are going to change the operating unit
1747: -- so hlding old BILL TO from SR will not be a valid one