DBA Data[Home] [Help]

APPS.OPI_DBI_RES_PKG dependencies on GMF_TRANSACTION_VALUATION

Line 1231: FROM gmf_transaction_valuation gtv,

1227: (
1228: SELECT gtv.transaction_id,
1229: gtv.accounted_flag,
1230: gtv.txn_base_value
1231: FROM gmf_transaction_valuation gtv,
1232: opi_dbi_run_log_curr log,
1233: opi_dbi_org_le_temp tmp
1234: WHERE nvl(gtv.accounted_flag, 'F') <> 'N'
1235: AND gtv.journal_line_type = 'WIP'

Line 1500: FROM gmf_transaction_valuation gtv,

1496: (
1497: SELECT gtv.transaction_id,
1498: gtv.accounted_flag,
1499: gtv.txn_base_value
1500: FROM gmf_transaction_valuation gtv,
1501: opi_dbi_run_log_curr log,
1502: opi_dbi_org_le_temp tmp
1503: WHERE gtv.accounted_flag is NULL
1504: AND gtv.journal_line_type = 'WIP'

Line 1519: FROM gmf_transaction_valuation gtv,

1515: UNION ALL
1516: SELECT gtv.transaction_id,
1517: gtv.accounted_flag,
1518: gtv.txn_base_value
1519: FROM gmf_transaction_valuation gtv,
1520: opi_dbi_org_le_temp tmp
1521: WHERE gtv.accounted_flag = 'D'
1522: AND gtv.journal_line_type = 'WIP'
1523: AND gtv.event_class_code = 'BATCH_RESOURCE'