DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on PO_SYSTEM_PARAMETERS_ALL

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