[Home] [Help]
147:
148: -- umxla_extract_gt; /* xxxremove */
149:
150: select count(*) into n_hdrs from gmf_xla_extract_headers_gt; -- xxxremove
151: select count(*) into n_lines from gmf_xla_extract_lines_gt; -- xxxremove
152:
153: g_log_msg := n_hdrs || ' rows in hdrs_gt and ' || n_lines || ' rows in lines_gt';
154:
155: print_debug(g_log_msg);
447: happens automatically when the data is commited after processing every 1000 records (profile: GL$COMMIT_COUNT). */
448:
449: /*
450: DELETE FROM gmf_xla_extract_headers_gt;
451: DELETE FROM gmf_xla_extract_lines_gt;
452: */
453: ---------------------------------------------------------------------
454: -- All done!
455: ---------------------------------------------------------------------
642: END IF;
643: END LOOP;
644:
645: IF l_cnt_hdr_msg < 0 THEN /* Bug 12647482 */
646: DELETE FROM gmf_xla_extract_lines_gt
647: where header_id in (SELECT header_id
648: FROM gmf_xla_extract_headers_gt
649: WHERE entity_code IS NULL or event_class_code IS NULL OR event_type_code IS NULL)
650: ;
1227: --
1228: -- B 7147477 include legal entity id so that unique index GMF_XLA_EXTRACT_HEADERS_U2 is used.
1229: -- bug 11807826, added event type code in the where clause for Lc valuatuion transactions
1230: -- bug13428401, modified the decode condition in the where clause
1231: UPDATE gmf_xla_extract_lines_gt elgt
1232: SET (header_id, event_id) =
1233: (SELECT
1234: eh.header_id, eh.event_id
1235: FROM
1270: -- reference_no <> g_reference_no AND
1271: header_id in
1272: (
1273: SELECT header_id
1274: FROM gmf_xla_extract_lines_gt elgt
1275: -- WHERE ehgt.header_id = el.header_id
1276: )
1277: ;
1278:
1364: , g_prog_appl_id
1365: , g_program_id
1366: , g_request_id
1367: FROM
1368: gmf_xla_extract_lines_gt elgt
1369: ;
1370:
1371: g_log_msg := sql%rowcount || ' rows inserted into extract_lines table';
1372:
1425: (select eh.transaction_id, eh.ledger_id, eh.valuation_cost_type_id,
1426: -- eh.transaction_source_type_id,
1427: eh.event_class_code
1428: from gmf_xla_extract_headers eh,
1429: gmf_xla_extract_lines_gt elgt
1430: where eh.header_id = elgt.header_id
1431: and eh.event_id = elgt.event_id
1432: )
1433: ;
1592: , elgt.cost_level
1593: , sum(elgt.BASE_AMOUNT_RAW) as txn_base_value_raw
1594: , sum(elgt.BASE_AMOUNT) as txn_base_value
1595: FROM gmf_xla_extract_headers eh,
1596: gmf_xla_extract_lines_gt elgt,
1597: mtl_system_items_kfv item,
1598: mtl_txn_source_types ts
1599: WHERE eh.header_id = elgt.header_id
1600: AND eh.event_id = elgt.event_id