DBA Data[Home] [Help]

APPS.CSP_AUTO_ASLMSL_PVT dependencies on CSP_USG_TRANSACTION_TYPES

Line 1277: from csp_usg_transaction_types cutt

1273: And (cuh.PERIOD_START_DATE BETWEEN (trunc(sysdate) - cfrb.forecast_periods
1274: * cfrb.period_size * l_ts_cycle) - cfrb.period_size * cfrb.history_periods - (cfrb.period_size - 1)
1275: AND (trunc(sysdate) - cfrb.forecast_periods * period_size * l_ts_cycle))
1276: And cuh.transaction_type_id in (select transaction_type_id
1277: from csp_usg_transaction_types cutt
1278: where cutt.forecast_rule_id = cpp.forecast_rule_id)
1279: And csi.inventory_item_id(+) = cuh.inventory_item_id
1280: And csi.organization_id (+) = cuh.organization_id
1281: And csi.sub_inventory_code(+) = cuh.subinventory_code