DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000006_PKG dependencies on AR_RCT_METHOD_H_V

Line 78727: WHEN 5 THEN 'AR_RCT_METHOD_H_V'

78723: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
78724: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
78725: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
78726: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78727: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
78728: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
78729: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
78730: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78731: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

Line 78728: WHEN 6 THEN 'AR_RCT_METHOD_H_V'

78724: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
78725: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
78726: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78727: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
78728: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
78729: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
78730: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
78731: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
78732: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

Line 78796: , AR_RCT_METHOD_H_V h4

78792: END source_value
78793: , null source_meaning
78794: FROM xla_events_gt xet
78795: , AR_CASH_RECEIPTS_H_V h1
78796: , AR_RCT_METHOD_H_V h4
78797: , AR_REMIT_BANK_ACCT_H_V h5
78798: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
78799: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78800: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 79120: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

79116: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
79117: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79118: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
79119: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79120: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79121: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79122: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79123: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 79121: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

79117: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79118: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
79119: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79120: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79121: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79122: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79123: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79125: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 79215: , AR_RCT_METHOD_H_V h4

79211: , h1.RCT_DOC_SEQUENCE_VALUE source_88
79212: , h1.RCT_TRX_ACCT_REVERSAL source_89
79213: FROM xla_events_gt xet
79214: , AR_CASH_RECEIPTS_H_V h1
79215: , AR_RCT_METHOD_H_V h4
79216: , AR_REMIT_BANK_ACCT_H_V h5
79217: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79218: and xet.event_class_code = C_EVENT_CLASS_CODE
79219: and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id

Line 80578: WHEN 9 THEN 'AR_RCT_METHOD_H_V'

80574: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
80575: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
80576: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
80577: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
80578: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
80579: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
80580: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
80581: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
80582: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'

Line 80579: WHEN 10 THEN 'AR_RCT_METHOD_H_V'

80575: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
80576: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
80577: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
80578: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
80579: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
80580: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
80581: WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
80582: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
80583: WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'

Line 80678: , AR_RCT_METHOD_H_V h6

80674: END source_value
80675: , null source_meaning
80676: FROM xla_events_gt xet
80677: , AR_CASH_RECEIPTS_H_V h2
80678: , AR_RCT_METHOD_H_V h6
80679: , AR_RCT_SITE_USES_H_V h7
80680: , AR_REMIT_BANK_ACCT_H_V h9
80681: , AR_SYSTEM_PARAM_H_V h10
80682: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)

Line 81115: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

81111: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
81112: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
81113: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
81114: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
81115: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
81116: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
81117: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
81118: TYPE t_array_source_77 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
81119: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 81116: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

81112: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
81113: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
81114: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
81115: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
81116: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
81117: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
81118: TYPE t_array_source_77 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
81119: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
81120: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 81263: , AR_RCT_METHOD_H_V h6

81259: , h2.RCT_DOC_SEQUENCE_VALUE source_88
81260: , h2.RCT_TRX_ACCT_REVERSAL source_89
81261: FROM xla_events_gt xet
81262: , AR_CASH_RECEIPTS_H_V h2
81263: , AR_RCT_METHOD_H_V h6
81264: , AR_RCT_SITE_USES_H_V h7
81265: , AR_REMIT_BANK_ACCT_H_V h9
81266: , AR_SYSTEM_PARAM_H_V h10
81267: WHERE xet.event_date between p_pad_start_date and p_pad_end_date