DBA Data[Home] [Help]

APPS.CSTPALBR dependencies on MFG_LOOKUPS

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

213: wt.transaction_id "transaction_id",
214: to_number(null) "transaction_action_id",
215: to_number(null) "transaction_source_type_id",
216: wt.transaction_type "transaction_type_id", -- Bug 4968702 Using the base tables Directly
217: (SELECT to_char(lookup_code) FROM mfg_lookups WHERE lookup_type = 'WIP_TRANSACTION_TYPE' AND lookup_code = wt.transaction_type) "EVENT_TYPE", -- Bug 4968702
218: 'WIP' "TRANSACTION_TYPE_FLAG", -- Bug 4968702
219: NULL "TRX_SOURCE_LINE_ID"
220: FROM
221: wip_transactions wt,