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.

[Home] [Help]

APPS.INVPVDR5 dependencies on GL_CODE_COMBINATIONS

Line 494: from GL_CODE_COMBINATIONS

490:
491: if cr.COST_OF_SALES_ACCOUNT is not null then
492: begin
493: select 'x' into temp
494: from GL_CODE_COMBINATIONS
495: where CODE_COMBINATION_ID = cr.COST_OF_SALES_ACCOUNT
496: and CHART_OF_ACCOUNTS_ID = chart_of_acc_id
497: and nvl(START_DATE_ACTIVE,sysdate) <= sysdate
498: and nvl(END_DATE_ACTIVE,sysdate) >= sysdate

Line 531: from GL_CODE_COMBINATIONS

527: -- validate foreign keys: SALES_ACCOUNT
528: if cr.SALES_ACCOUNT is not null then
529: begin
530: select 'x' into temp
531: from GL_CODE_COMBINATIONS
532: where CODE_COMBINATION_ID = cr.SALES_ACCOUNT
533: and CHART_OF_ACCOUNTS_ID = chart_of_acc_id
534: and nvl(START_DATE_ACTIVE,sysdate) <= sysdate
535: and nvl(END_DATE_ACTIVE,sysdate) >= sysdate

Line 569: from GL_CODE_COMBINATIONS

565: -- validate Expense_account
566: if cr.EXPENSE_ACCOUNT is not null then
567: begin
568: select 'x' into temp
569: from GL_CODE_COMBINATIONS
570: where CODE_COMBINATION_ID = cr.EXPENSE_ACCOUNT
571: and CHART_OF_ACCOUNTS_ID = chart_of_acc_id
572: and nvl(START_DATE_ACTIVE,sysdate) <= sysdate
573: and nvl(END_DATE_ACTIVE,sysdate) >= sysdate

Line 606: from GL_CODE_COMBINATIONS

602: -- validate Encumbrance Account
603: if cr.ENCUMBRANCE_ACCOUNT is not null then
604: begin
605: select 'x' into temp
606: from GL_CODE_COMBINATIONS
607: where CODE_COMBINATION_ID = cr.ENCUMBRANCE_ACCOUNT
608: and CHART_OF_ACCOUNTS_ID = chart_of_acc_id
609: and nvl(START_DATE_ACTIVE,sysdate) <= sysdate
610: and nvl(END_DATE_ACTIVE,sysdate) >= sysdate