APPS.FII_AR_TRX_DIST_F_D SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

  select warehouse_to_instance_link
  into   g_db_link
  from   edw_source_instances
  where  instance_code = g_instance_code;

Line: 41

  SELECT tablespace_name
  INTO   g_tablespace
  FROM   all_tables
  WHERE  table_name = 'FII_AR_TRX_DIST_FSTG'
  AND    owner = g_fii_schema;

Line: 98

  l_stmt := 'insert into '||g_fii_schema||'.FII_AR_OLTP_TMP_TRX_ID '||
            'select /*+ PARALLEL(TRX,10) */ '||
            '     customer_trx_id trx_id '||
            'from   ra_customer_trx_all@'||g_db_link||' TRX';

Line: 122

          'as select  /*+ PARALLEL(F,10) */  '||
          'distinct '||
          'to_number(invoice_id) trx_id '||
	  'from  fii_ar_trx_dist_f  F  '||
          'where transaction_class <> ''ADJ'' '||
          'and   invoice_pk like ''%'||g_instance_code||'%'' ';

Line: 143

  l_stmt := 'select count(*) from '||g_fii_schema||'.FII_AR_EDW_EXTRA_ID ';

Line: 162

	    'as select	trx_id '||
	    'from '||g_fii_schema||'.FII_AR_EDW_TMP_TRX_ID '||
	    'where	trx_id in '||
	    '       (select /*+ PARALLEL(EDW,5) */ trx_id '||
	    '        from '||g_fii_schema||'.FII_AR_EDW_TMP_TRX_ID EDW '||
	    '         minus '||
	    '        select /*+ PARALLEL(OLTP,5) */ trx_id '||
	    '        from '||g_fii_schema||'.FII_AR_OLTP_TMP_TRX_ID OLTP) ';

Line: 184

PROCEDURE Insert_Staging (l_row OUT NOCOPY /* file.sql.39 change */ NUMBER)  IS
  l_stmt varchar2(2000);

Line: 191

   'insert into FII_AR_TRX_DIST_FSTG(  '||
' INVOICE_PK, '||
' OPERATION_CODE, '||
' COLLECTION_STATUS, '||
'INVOICE_ID, '||
' ORIGINAL_INVOICE_ID, '||
' ORIGINAL_INVOICE_LINE_ID, '||
' END_USER_CUSTOMER_FK, '||
' RESELLER_CUSTOMER_FK, '||
' INVOICE_DATE_FK, '||
' SALES_ORDER_DATE_FK, '||
' INVOICE_LINE_ID, '||
' FUNCTIONAL_CURRENCY_FK, '||
' BILL_TO_CUSTOMER_FK, '||
' BILL_TO_SITE_FK, '||
' CAMPAIGN_ACTL_FK, '||
' CAMPAIGN_INIT_FK, '||
' CELL_ACTL_FK, '||
' CELL_INIT_FK, '||
' EVENT_OFFER_ACTL_FK, '||
' EVENT_OFFER_INIT_FK, '||
' EVENT_OFFER_REG_FK, '||
' GL_ACCT10_FK, '||
' GL_ACCT1_FK, '||
' GL_ACCT2_FK, '||
' GL_ACCT3_FK, '||
' GL_ACCT4_FK, '||
' GL_ACCT5_FK, '||
' GL_ACCT6_FK, '||
' GL_ACCT7_FK, '||
' GL_ACCT8_FK, '||
' GL_ACCT9_FK, '||
' GL_DATE_FK , '||
' SET_OF_BOOKS_FK, '||
' INSTANCE_FK, '||
' ITEM_FK, '||
' MARKET_SEGMENT_FK, '||
' MEDIA_ACTL_FK, '||
' MEDIA_INIT_FK, '||
' OFFER_ACTL_FK, '||
' OFFER_INIT_FK, '||
' ORGANIZATION_FK, '||
' PARENT_ITEM_FK, '||
' PAYMENT_TERM_FK, '||
' PRIM_SALESREP_FK, '||
' PROJECT_FK, '||
' SALESCHANNEL_FK, '||
' SALESREP_FK, '||
' SHIP_TO_CUSTOMER_FK, '||
' SHIP_TO_SITE_FK, '||
' SIC_CODE_FK, '||
' SOLD_TO_CUSTOMER_FK, '||
' SOLD_TO_SITE_FK, '||
' SOURCE_LIST_FK, '||
' TRANSACTION_CURRENCY_FK, '||
' UOM_FK, '||
' USER_FK1, '||
' USER_FK2, '||
' USER_FK3, '||
' USER_FK4, '||
' USER_FK5, '||
' CAMPAIGN_STATUS_INIT_FK, '||
' CAMPAIGN_STATUS_ACTL_FK,  '||
' CREATION_DATE,  '||
' LAST_UPDATE_DATE)  '||
'select  '||
'f.invoice_pk, '||
'''DELETE'','||
'''READY'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'''NA_EDW'','||
'sysdate, '||
'sysdate  '||
'from '||g_fii_schema||'.FII_AR_EDW_EXTRA_ID extra, '||
'FII_AR_TRX_DIST_F f  '||
'where f.invoice_id = extra.trx_id  '||
'and  f.invoice_pk like ''%'||g_instance_code||'%'' ';

Line: 334

End Insert_Staging;