DBA Data[Home] [Help]

APPS.CSP_AUTO_ASLMSL_PVT dependencies on CSP_USG_TRANSACTION_TYPES

Line 1168: from csp_usg_transaction_types cutt

1164: and cpp.secondary_inventory is null
1165: and cpp.organization_type = 'W'
1166: and cuh.transaction_type_id in
1167: (select transaction_type_id
1168: from csp_usg_transaction_types cutt
1169: where cutt.forecast_rule_id = cpp.forecast_rule_id)
1170: group by cuh.organization_id,
1171: cuh.inventory_item_id,
1172: cuh.period_start_date;

Line 1297: from csp_usg_transaction_types cutt

1293: And (cuh.PERIOD_START_DATE BETWEEN (trunc(sysdate) - cfrb.forecast_periods
1294: * cfrb.period_size * l_ts_cycle) - cfrb.period_size * cfrb.history_periods - (cfrb.period_size - 1)
1295: AND (trunc(sysdate) - cfrb.forecast_periods * period_size * l_ts_cycle))
1296: And cuh.transaction_type_id in (select transaction_type_id
1297: from csp_usg_transaction_types cutt
1298: where cutt.forecast_rule_id = cpp.forecast_rule_id)
1299: And csi.inventory_item_id(+) = cuh.inventory_item_id
1300: And csi.organization_id (+) = cuh.organization_id
1301: And csi.sub_inventory_code(+) = cuh.subinventory_code