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.JA_CN_COA_EXP_PKG dependencies on FND_LOOKUP_VALUES

Line 452: l_na_req_phase fnd_lookup_values.meaning%TYPE;

448: l_template_language VARCHAR2(10) := P_XML_TEMPLATE_LANGUAGE;
449: l_template_territory VARCHAR2(10) := P_XML_TEMPLATE_TERRITORY;
450: l_output_format VARCHAR2(10) := P_XML_OUTPUT_FORMAT;
451: l_na_req_id NUMBER; --Request id for concurrent program 'Generating Natural Account Export Exception Report'
452: l_na_req_phase fnd_lookup_values.meaning%TYPE;
453: l_na_req_status fnd_lookup_values.meaning%TYPE;
454: l_na_req_dev_phase VARCHAR2(30);
455: l_na_req_dev_status VARCHAR2(30);
456: l_na_req_message VARCHAR2(100);

Line 453: l_na_req_status fnd_lookup_values.meaning%TYPE;

449: l_template_territory VARCHAR2(10) := P_XML_TEMPLATE_TERRITORY;
450: l_output_format VARCHAR2(10) := P_XML_OUTPUT_FORMAT;
451: l_na_req_id NUMBER; --Request id for concurrent program 'Generating Natural Account Export Exception Report'
452: l_na_req_phase fnd_lookup_values.meaning%TYPE;
453: l_na_req_status fnd_lookup_values.meaning%TYPE;
454: l_na_req_dev_phase VARCHAR2(30);
455: l_na_req_dev_status VARCHAR2(30);
456: l_na_req_message VARCHAR2(100);
457:

Line 604: FROM FND_LOOKUP_VALUES FLV

600: --Get meaning of Subsidiary Accounts
601: -- project meaning
602: SELECT FLV.meaning
603: INTO l_project_meaning
604: FROM FND_LOOKUP_VALUES FLV
605: WHERE FLV.lookup_code = 'PJ'
606: and FLV.lookup_type = 'JA_CN_SUBSIDIARY_GROUP'
607: and FLV.LANGUAGE = userenv('LANG')
608: ;

Line 612: FROM FND_LOOKUP_VALUES FLV

608: ;
609: -- third party meaning
610: SELECT FLV.meaning
611: INTO l_thirdparty_meaning
612: FROM FND_LOOKUP_VALUES FLV
613: WHERE FLV.lookup_code = 'TP'
614: and FLV.lookup_type = 'JA_CN_SUBSIDIARY_GROUP'
615: and FLV.LANGUAGE = userenv('LANG')
616: ;

Line 620: FROM FND_LOOKUP_VALUES FLV

616: ;
617: -- supplier meaning
618: SELECT FLV.meaning
619: INTO l_supplier_meaning
620: FROM FND_LOOKUP_VALUES FLV
621: WHERE FLV.lookup_code = 'S'
622: and FLV.lookup_type = 'JA_CN_THIRDPARTY_TYPE'
623: and FLV.LANGUAGE = userenv('LANG')
624: ;

Line 628: FROM FND_LOOKUP_VALUES FLV

624: ;
625: -- custmor meaning
626: SELECT FLV.meaning
627: INTO l_customer_meaning
628: FROM FND_LOOKUP_VALUES FLV
629: WHERE FLV.lookup_code = 'C'
630: and FLV.lookup_type = 'JA_CN_THIRDPARTY_TYPE'
631: and FLV.LANGUAGE = userenv('LANG')
632: ;

Line 637: FROM FND_LOOKUP_VALUES FLV

633:
634: -- cost center meaning
635: SELECT FLV.meaning
636: INTO l_costcenter_meaning
637: FROM FND_LOOKUP_VALUES FLV
638: WHERE FLV.lookup_code = 'CC'
639: and FLV.lookup_type = 'JA_CN_SUBSIDIARY_GROUP'
640: and FLV.LANGUAGE = userenv('LANG')
641: ;

Line 645: FROM FND_LOOKUP_VALUES FLV

641: ;
642: -- person meaning
643: SELECT FLV.meaning
644: INTO l_personnel_meaning
645: FROM FND_LOOKUP_VALUES FLV
646: WHERE FLV.lookup_code = 'PERSON'
647: and FLV.lookup_type = 'JA_CN_SUBSIDIARY_GROUP'
648: and FLV.LANGUAGE = userenv('LANG')
649: ;

Line 953: FROM FND_LOOKUP_VALUES FLV

949: SELECT nvl(FLV.meaning,'') acc_type
950: ,FLV1.meaning acc_bal_side
951: INTO l_na_type
952: ,l_na_bal
953: FROM FND_LOOKUP_VALUES FLV
954: ,FND_LOOKUP_VALUES FLV1
955: WHERE --Get meaning of account type
956: FLV.lookup_code = l_acc_type_code --using variable l_acc_type_code
957: AND FLV.lookup_type = l_ent_acc_type --'ACCOUNT_TYPE'

Line 954: ,FND_LOOKUP_VALUES FLV1

950: ,FLV1.meaning acc_bal_side
951: INTO l_na_type
952: ,l_na_bal
953: FROM FND_LOOKUP_VALUES FLV
954: ,FND_LOOKUP_VALUES FLV1
955: WHERE --Get meaning of account type
956: FLV.lookup_code = l_acc_type_code --using variable l_acc_type_code
957: AND FLV.lookup_type = l_ent_acc_type --'ACCOUNT_TYPE'
958: and FLV.LANGUAGE = userenv('LANG')

Line 1461: FROM FND_LOOKUP_VALUES FLV

1457: SELECT nvl(FLV.meaning,'') sup_meaning
1458: ,nvl(FLV1.meaning,'') cust_meaning
1459: INTO l_sup_meaning
1460: ,l_cust_meaning
1461: FROM FND_LOOKUP_VALUES FLV
1462: ,FND_LOOKUP_VALUES FLV1
1463: WHERE FLV.lookup_code = 'S'
1464: AND FLV.lookup_type = 'JA_CN_THIRDPARTY_TYPE'
1465: AND FLV.LANGUAGE = userenv('LANG')

Line 1462: ,FND_LOOKUP_VALUES FLV1

1458: ,nvl(FLV1.meaning,'') cust_meaning
1459: INTO l_sup_meaning
1460: ,l_cust_meaning
1461: FROM FND_LOOKUP_VALUES FLV
1462: ,FND_LOOKUP_VALUES FLV1
1463: WHERE FLV.lookup_code = 'S'
1464: AND FLV.lookup_type = 'JA_CN_THIRDPARTY_TYPE'
1465: AND FLV.LANGUAGE = userenv('LANG')
1466: AND FLV1.lookup_code = 'C'