APPS.GMF_XLA_PKG dependencies on GMF_XLA_EXTRACT_LINES_GT

Line 144: select count(*) into n_lines from gmf_xla_extract_lines_gt; -- xxxremove

140:
141: -- umxla_extract_gt; /* xxxremove */
142:
143: select count(*) into n_hdrs from gmf_xla_extract_headers_gt; -- xxxremove
144: select count(*) into n_lines from gmf_xla_extract_lines_gt; -- xxxremove
145:
146: g_log_msg := n_hdrs || ' rows in hdrs_gt and ' || n_lines || ' rows in lines_gt';
147:
148: print_debug(g_log_msg);

Line 438: DELETE FROM gmf_xla_extract_lines_gt;

434: );
435: END IF;
436:
437: DELETE FROM gmf_xla_extract_headers_gt;
438: DELETE FROM gmf_xla_extract_lines_gt;
439:
440: ---------------------------------------------------------------------
441: -- All done!
442: ---------------------------------------------------------------------

Line 627: DELETE FROM gmf_xla_extract_lines_gt

623: );
624: END IF;
625: END LOOP;
626:
627: DELETE FROM gmf_xla_extract_lines_gt
628: where header_id in (SELECT header_id
629: FROM gmf_xla_extract_headers_gt
630: WHERE entity_code IS NULL or event_class_code IS NULL OR event_type_code IS NULL)
631: ;

Line 1193: UPDATE gmf_xla_extract_lines_gt elgt

1189: --
1190: -- First, set the header_id and event_id in extract_lines_gt table
1191: --
1192: -- B 7147477 include legal entity id so that unique index GMF_XLA_EXTRACT_HEADERS_U2 is used.
1193: UPDATE gmf_xla_extract_lines_gt elgt
1194: SET (header_id, event_id) =
1195: (SELECT
1196: eh.header_id, eh.event_id
1197: FROM

Line 1236: FROM gmf_xla_extract_lines_gt elgt

1232: -- reference_no <> g_reference_no AND
1233: header_id in
1234: (
1235: SELECT header_id
1236: FROM gmf_xla_extract_lines_gt elgt
1237: -- WHERE ehgt.header_id = el.header_id
1238: )
1239: ;
1240:

Line 1329: gmf_xla_extract_lines_gt elgt

1325: , g_prog_appl_id
1326: , g_program_id
1327: , g_request_id
1328: FROM
1329: gmf_xla_extract_lines_gt elgt
1330: ;
1331:
1332: g_log_msg := sql%rowcount || ' rows inserted into extract_lines table';
1333:

Line 1388: gmf_xla_extract_lines_gt elgt

1384: (select eh.transaction_id, eh.ledger_id, eh.valuation_cost_type_id,
1385: -- eh.transaction_source_type_id,
1386: eh.event_class_code
1387: from gmf_xla_extract_headers eh,
1388: gmf_xla_extract_lines_gt elgt
1389: where eh.header_id = elgt.header_id
1390: and eh.event_id = elgt.event_id
1391: )
1392: ;

Line 1547: gmf_xla_extract_lines_gt elgt,

1543: , elgt.cost_level
1544: , sum(elgt.BASE_AMOUNT_RAW) as txn_base_value_raw
1545: , sum(elgt.BASE_AMOUNT) as txn_base_value
1546: FROM gmf_xla_extract_headers eh,
1547: gmf_xla_extract_lines_gt elgt,
1548: mtl_system_items_kfv item,
1549: mtl_txn_source_types ts
1550: WHERE eh.header_id = elgt.header_id
1551: AND eh.event_id = elgt.event_id