DBA Data[Home] [Help]

APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on MTL_TRANSACTION_ACCOUNTS

Line 655: mtl_transaction_accounts mtain,

651: mtain.transaction_id,
652: mtain.transaction_date,
653: SUM(mtain.BASE_TRANSACTION_VALUE) BASE_TRANSACTION_VALUE
654: from
655: mtl_transaction_accounts mtain,
656: OPI_DBI_RUN_LOG_CURR log
657: where
658: mtain.accounting_line_type = 7 /* WIP valuation */ and
659: mtain.transaction_source_type_id = 5 /* Job or schedule */ and

Line 896: mtl_transaction_accounts mtain,

892: mtain.transaction_id,
893: mtain.transaction_date,
894: SUM(mtain.BASE_TRANSACTION_VALUE) BASE_TRANSACTION_VALUE
895: from
896: mtl_transaction_accounts mtain,
897: OPI_DBI_RUN_LOG_CURR log
898: where
899: mtain.accounting_line_type = 7 /* WIP valuation */ and
900: mtain.transaction_source_type_id = 5 /* Job or schedule */ and