DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on PO_SYSTEM_PARAMETERS_ALL

Line 1268: FROM PO_SYSTEM_PARAMETERS_ALL psp,

1264: SELECT psp.line_type_id,
1265: plt.order_type_lookup_code,
1266: plt.purchase_basis,
1267: plt.matching_basis
1268: FROM PO_SYSTEM_PARAMETERS_ALL psp,
1269: PO_LINE_TYPES plt
1270: WHERE psp.org_id = l_org_id
1271: AND plt.line_type_id = psp.line_type_id;
1272:

Line 2259: FROM PO_SYSTEM_PARAMETERS_ALL

2255:
2256: if l_is_valid_order_type <> 1 then
2257: SELECT ORDER_TYPE_ID
2258: INTO l_header_rec.order_type_id
2259: FROM PO_SYSTEM_PARAMETERS_ALL
2260: WHERE ORG_ID = l_source_operating_unit;
2261: end if;
2262:
2263: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then