APPS.OPI_DBI_COGS_PKG dependencies on GMF_TRANSACTION_VALUATION

Line 686: FROM gmf_transaction_valuation gtv,

682: gtv.line_id,
683: gtv.transaction_date,
684: sum(decode(gtv.accounted_flag, 'D', -gtv.txn_base_value, 0)) draft_value,
685: sum(decode(gtv.accounted_flag, 'D', 0, -gtv.txn_base_value)) final_value
686: FROM gmf_transaction_valuation gtv,
687: opi_dbi_org_le_temp tmp
688: WHERE gtv.transaction_type_id in (33, 34, 62)
689: AND nvl(gtv.accounted_flag, 'F') <> 'N'
690: AND nvl(gtv.final_posting_date, p_from_bound_date) >= p_from_bound_date

Line 741: FROM gmf_transaction_valuation gtv,

737: gtv.line_id,
738: gtv.transaction_date,
739: sum(decode(gtv.accounted_flag, 'D', -gtv.txn_base_value, 0)) draft_value,
740: sum(decode(gtv.accounted_flag, 'D', 0, -gtv.txn_base_value)) final_value
741: FROM gmf_transaction_valuation gtv,
742: opi_dbi_org_le_temp tmp
743: WHERE gtv.transaction_type_id in (37, 16, 15)
744: AND nvl(gtv.accounted_flag, 'F') <> 'N'
745: AND nvl(gtv.final_posting_date, p_from_bound_date) >= p_from_bound_date

Line 799: FROM gmf_transaction_valuation gtv,

795: gtv.line_id,
796: gtv.transaction_date,
797: sum(decode(gtv.accounted_flag, 'D', -gtv.txn_base_value, 0)) draft_value,
798: sum(decode(gtv.accounted_flag, 'D', 0, -gtv.txn_base_value)) final_value
799: FROM gmf_transaction_valuation gtv,
800: opi_dbi_org_le_temp tmp
801: WHERE gtv.transaction_type_id in (11, 30) -- 11 Logical intercompany sales issue
802: -- 30 Logical sales order issue
803: AND nvl(gtv.accounted_flag, 'F') <> 'N'

Line 1007: FROM gmf_transaction_valuation gtv,

1003: gtv.line_id,
1004: gtv.transaction_date,
1005: sum(-gtv.txn_base_value) draft_value,
1006: 0 final_value
1007: FROM gmf_transaction_valuation gtv,
1008: opi_dbi_org_le_temp tmp
1009: WHERE gtv.transaction_type_id in (33, 34, 62)
1010: AND gtv.accounted_flag = 'D'
1011: AND gtv.transaction_date >= g_global_start_date

Line 1031: FROM gmf_transaction_valuation gtv,

1027: gtv.line_id,
1028: gtv.transaction_date,
1029: 0 draft_value,
1030: sum(-gtv.txn_base_value) final_value
1031: FROM gmf_transaction_valuation gtv,
1032: opi_dbi_org_le_temp tmp
1033: WHERE gtv.transaction_type_id in (33, 34, 62)
1034: AND gtv.accounted_flag is NULL
1035: AND gtv.final_posting_date >= p_from_bound_date

Line 1086: FROM gmf_transaction_valuation gtv,

1082: gtv.line_id,
1083: gtv.transaction_date,
1084: sum(-gtv.txn_base_value) draft_value,
1085: 0 final_value
1086: FROM gmf_transaction_valuation gtv,
1087: opi_dbi_org_le_temp tmp
1088: WHERE gtv.transaction_type_id in (37, 16, 15)
1089: AND gtv.accounted_flag = 'D'
1090: AND gtv.transaction_date >= g_global_start_date

Line 1110: FROM gmf_transaction_valuation gtv,

1106: gtv.line_id,
1107: gtv.transaction_date,
1108: 0 draft_value,
1109: sum(-gtv.txn_base_value) final_value
1110: FROM gmf_transaction_valuation gtv,
1111: opi_dbi_org_le_temp tmp
1112: WHERE gtv.transaction_type_id in (37, 16, 15)
1113: AND gtv.accounted_flag is NULL
1114: AND gtv.final_posting_date >= p_from_bound_date

Line 1168: FROM gmf_transaction_valuation gtv,

1164: gtv.line_id,
1165: gtv.transaction_date,
1166: sum(-gtv.txn_base_value) draft_value,
1167: 0 final_value
1168: FROM gmf_transaction_valuation gtv,
1169: opi_dbi_org_le_temp tmp
1170: WHERE gtv.transaction_type_id in (11, 30) -- 11 Logical intercompany sales issue
1171: -- 30 Logical sales order issue
1172: AND gtv.accounted_flag = 'D'

Line 1193: FROM gmf_transaction_valuation gtv,

1189: gtv.line_id,
1190: gtv.transaction_date,
1191: 0 draft_value,
1192: sum(-gtv.txn_base_value) final_value
1193: FROM gmf_transaction_valuation gtv,
1194: opi_dbi_org_le_temp tmp
1195: WHERE gtv.transaction_type_id in (11, 30) -- 11 Logical intercompany sales issue
1196: -- 30 Logical sales order issue
1197: AND gtv.accounted_flag is NULL