DBA Data[Home] [Help]

APPS.CSTPALBR dependencies on MFG_LOOKUPS

Line 199: (SELECT to_char(lookup_code) FROM mfg_lookups WHERE lookup_type = 'WIP_TRANSACTION_TYPE' AND lookup_code = wt.transaction_type) "EVENT_TYPE", -- Bug 4968702

195: wt.transaction_id "transaction_id",
196: to_number(null) "transaction_action_id",
197: to_number(null) "transaction_source_type_id",
198: wt.transaction_type "transaction_type_id", -- Bug 4968702 Using the base tables Directly
199: (SELECT to_char(lookup_code) FROM mfg_lookups WHERE lookup_type = 'WIP_TRANSACTION_TYPE' AND lookup_code = wt.transaction_type) "EVENT_TYPE", -- Bug 4968702
200: 'WIP' "TRANSACTION_TYPE_FLAG", -- Bug 4968702
201: NULL "TRX_SOURCE_LINE_ID"
202: FROM
203: wip_transactions wt,