eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGIRCBJP dependencies on AR_RECEIVABLE_APPLICATIONS

Line 43: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,

39: -- RECORD holder for pertinent information from a receivable application
40: -- of status = 'APP'
41: TYPE ApplicationType IS RECORD
42: (
43: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,
44: GLDate DATE, -- the gl date of the application
45: TrxDate DATE, -- the apply date of the application
46: AppType ar_receivable_applications.application_type%TYPE,
47: CatMeaning ar_lookups.meaning%TYPE,

Line 46: AppType ar_receivable_applications.application_type%TYPE,

42: (
43: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,
44: GLDate DATE, -- the gl date of the application
45: TrxDate DATE, -- the apply date of the application
46: AppType ar_receivable_applications.application_type%TYPE,
47: CatMeaning ar_lookups.meaning%TYPE,
48: PostingControlId ar_receivable_applications.posting_control_id%TYPE
49: );
50: --

Line 48: PostingControlId ar_receivable_applications.posting_control_id%TYPE

44: GLDate DATE, -- the gl date of the application
45: TrxDate DATE, -- the apply date of the application
46: AppType ar_receivable_applications.application_type%TYPE,
47: CatMeaning ar_lookups.meaning%TYPE,
48: PostingControlId ar_receivable_applications.posting_control_id%TYPE
49: );
50: --
51: -- holds ApplicationAmount values
52: --

Line 1143: -- post ar_receivable_applications that have status UNAPP, UNID, ACC

1139: RAISE;
1140: END;
1141: --
1142: --
1143: -- post ar_receivable_applications that have status UNAPP, UNID, ACC
1144: --
1145: /*---------------------------------------------------------------------------*
1146: | PRIVATE PROCEDURE |
1147: | ReportNonDistApplications |

Line 1149: | non-APP ar_receivable_applications records |

1145: /*---------------------------------------------------------------------------*
1146: | PRIVATE PROCEDURE |
1147: | ReportNonDistApplications |
1148: | DESCRIPTION |
1149: | non-APP ar_receivable_applications records |
1150: | |
1151: | |
1152: | PARAMETERS |
1153: | |

Line 1183: FROM ar_receivable_applications ra,

1179: ra.acctd_amount_applied_from AcctdAmount,
1180: ra.code_combination_id CodeCombinationId,
1181: ra.status Status,
1182: l_cat.meaning CatMeaning
1183: FROM ar_receivable_applications ra,
1184: igi_ar_rec_applications igira,
1185: ar_cash_receipts cr,
1186: hz_parties, -- Bug 3902175
1187: hz_cust_accounts, -- Bug 3902175

Line 1261: WriteToLogFile( l_state_level, 'ReportNonDistApplications',' AR_RECEIVABLE_APPLICATIONS (non-app)...' );

1257: l_Count NUMBER :=0;
1258:
1259: BEGIN
1260: WriteToLogFile( l_state_level, 'ReportNonDistApplications',' ' );
1261: WriteToLogFile( l_state_level, 'ReportNonDistApplications',' AR_RECEIVABLE_APPLICATIONS (non-app)...' );
1262: FOR RRa IN CRa
1263: LOOP
1264: BEGIN
1265:

Line 1348: 'AR_RECEIVABLE_APPLICATIONS' -- reference30

1344: decode(RRa.AmountAppFrom,
1345: null,'TRADE','CROSS CURR'), -- reference28
1346: decode(RRa.AmountAppFrom,
1347: null,'TRADE_APP','CCURR_APP'), -- reference29
1348: 'AR_RECEIVABLE_APPLICATIONS' -- reference30
1349: );
1350: EXCEPTION
1351: WHEN OTHERS THEN
1352: WriteToLogFile( l_excep_level,'ReportNonDistApplications','Exception:ReportNonDistApplications.INSERT:' );

Line 1384: | post unposted ar_receivable_applications records |

1380: | PRIVATE PROCEDURE |
1381: | ReportDistributedApplications |
1382: | |
1383: | DESCRIPTION |
1384: | post unposted ar_receivable_applications records |
1385: | post unposted ar_receivable_applications records |
1386: | We need to have ORDER BY clause in the select statement because |
1387: | when comparing with GL Transfer entries, they need to match, |
1388: | If order by is not used, there will be rounding difference. |

Line 1385: | post unposted ar_receivable_applications records |

1381: | ReportDistributedApplications |
1382: | |
1383: | DESCRIPTION |
1384: | post unposted ar_receivable_applications records |
1385: | post unposted ar_receivable_applications records |
1386: | We need to have ORDER BY clause in the select statement because |
1387: | when comparing with GL Transfer entries, they need to match, |
1388: | If order by is not used, there will be rounding difference. |
1389: | |

Line 1472: FROM ar_receivable_applications ra,

1468: '2', NVL(-ra.receivables_charges_applied,0)
1469: ) ChargesApplied,
1470: l_cat.meaning CatMeaning,
1471: igira.arc_posting_control_id PostingControlId
1472: FROM ar_receivable_applications ra,
1473: igi_ar_rec_applications igira,
1474: ra_cust_trx_types ctt,
1475: ra_customer_trx ct,
1476: ar_cash_receipts cr,

Line 2174: l_ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE;

2170: AND i.reference28 = p_CategoryCode
2171: ORDER BY i.reference30,
2172: i.reference23;
2173: --
2174: l_ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE;
2175: BEGIN
2176: --
2177: WriteToOutFile( ' ----------------------------------------------------' );
2178: WriteToOutFile( ' Checking DR/CR balance...' );

Line 2652: , ar_receivable_applications_s.nextval

2648: --
2649: -- Set Max IDs
2650: --
2651: SELECT ar_cash_receipt_history_s.nextval
2652: , ar_receivable_applications_s.nextval
2653: , ar_misc_cash_distributions_s.nextval
2654: , ar_adjustments_s.nextval
2655: , ra_cust_trx_line_gl_dist_s.nextval
2656: INTO l_Report.NxtCashReceiptHistoryId