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.ZX_PRD_OPTIONS_MIGRATE_PKG dependencies on ZX_PRODUCT_OPTIONS_ALL

Line 186: FROM ZX_PRODUCT_OPTIONS_ALL prd

182: FROM AP_SYSTEM_PARAMETERS_ALL sys,
183: FINANCIALS_SYSTEM_PARAMS_ALL fin
184: WHERE decode(l_multi_org_flag,'N',l_org_id,fin.org_id(+)) = decode(l_multi_org_flag,'N',l_org_id,sys.org_id)
185: AND NOT EXISTS (SELECT 1
186: FROM ZX_PRODUCT_OPTIONS_ALL prd
187: WHERE prd.ORG_ID = decode(l_multi_org_flag,'N',l_org_id,sys.org_id)
188: AND prd.APPLICATION_ID = 200
189: );
190:

Line 310: INSERT INTO ZX_PRODUCT_OPTIONS_ALL (

306: END LOOP;
307: END LOOP;
308:
309: FORALL i in 1..nvl(ap_system_options.org_id.LAST,0)
310: INSERT INTO ZX_PRODUCT_OPTIONS_ALL (
311: PRODUCT_OPTIONS_ID,
312: ORG_ID,
313: APPLICATION_ID,
314: DEF_OPTION_HIER_1_CODE,

Line 341: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,

337: LAST_UPDATE_DATE,
338: LAST_UPDATED_BY,
339: LAST_UPDATE_LOGIN
340: )
341: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,
342: ap_system_options.ORG_ID(i),
343: 200, --application_id
344: ap_system_options.DEFAULT_HIERARCHY1(i),
345: ap_system_options.DEFAULT_HIERARCHY2(i),

Line 478: FROM ZX_PRODUCT_OPTIONS_ALL prd

474: FROM AR_SYSTEM_PARAMETERS_ALL sys,
475: FINANCIALS_SYSTEM_PARAMS_ALL fin
476: WHERE decode(l_multi_org_flag,'N',l_org_id,fin.org_id(+)) = decode(l_multi_org_flag,'N',l_org_id,sys.org_id)
477: AND NOT EXISTS (SELECT 1
478: FROM ZX_PRODUCT_OPTIONS_ALL prd
479: WHERE prd.ORG_ID = decode(l_multi_org_flag,'N',l_org_id,sys.org_id)
480: AND prd.APPLICATION_ID = 222
481: );
482:

Line 550: INSERT INTO ZX_PRODUCT_OPTIONS_ALL (

546: END LOOP;
547: END LOOP;
548:
549: FORALL i in 1..nvl(ar_system_options.org_id.LAST,0)
550: INSERT INTO ZX_PRODUCT_OPTIONS_ALL (
551: PRODUCT_OPTIONS_ID,
552: ORG_ID,
553: APPLICATION_ID,
554: DEF_OPTION_HIER_1_CODE,

Line 582: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,

578: LAST_UPDATE_DATE,
579: LAST_UPDATED_BY,
580: LAST_UPDATE_LOGIN
581: )
582: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,
583: ar_system_options.ORG_ID(i),
584: 222, --application_id
585: ar_system_options.DEFAULT_HIERARCHY1(i),
586: ar_system_options.DEFAULT_HIERARCHY2(i),

Line 706: FROM ZX_PRODUCT_OPTIONS_ALL prd

702: FROM PO_SYSTEM_PARAMETERS_ALL sys,
703: FINANCIALS_SYSTEM_PARAMS_ALL fin
704: WHERE decode(l_multi_org_flag,'N',l_org_id,fin.org_id(+))= decode(l_multi_org_flag,'N',l_org_id,sys.org_id)
705: AND NOT EXISTS (SELECT 1
706: FROM ZX_PRODUCT_OPTIONS_ALL prd
707: WHERE prd.ORG_ID = decode(l_multi_org_flag,'N',l_org_id,sys.org_id)
708: AND prd.APPLICATION_ID = 201
709: );
710:

Line 778: INSERT INTO ZX_PRODUCT_OPTIONS_ALL (

774: END LOOP;
775: END LOOP;
776:
777: FORALL i in 1..nvl(po_system_options.org_id.LAST,0)
778: INSERT INTO ZX_PRODUCT_OPTIONS_ALL (
779: PRODUCT_OPTIONS_ID,
780: ORG_ID,
781: APPLICATION_ID,
782: DEF_OPTION_HIER_1_CODE,

Line 807: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,

803: LAST_UPDATE_DATE,
804: LAST_UPDATED_BY,
805: LAST_UPDATE_LOGIN
806: )
807: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,
808: po_system_options.ORG_ID(i),
809: 201, --application_id
810: po_system_options.DEFAULT_HIERARCHY1(i),
811: po_system_options.DEFAULT_HIERARCHY2(i),

Line 936: FROM ZX_PRODUCT_OPTIONS_ALL prd

932: FROM PA_IMPLEMENTATIONS_ALL sys,
933: AR_SYSTEM_PARAMETERS_ALL receivable
934: WHERE decode(l_multi_org_flag,'N',l_org_id,receivable.ORG_ID(+)) = decode(l_multi_org_flag,'N',l_org_id,sys.ORG_ID)
935: AND NOT EXISTS (SELECT 1
936: FROM ZX_PRODUCT_OPTIONS_ALL prd
937: WHERE prd.ORG_ID = decode(l_multi_org_flag,'N',l_org_id,sys.org_id)
938: AND prd.APPLICATION_ID = 275
939: );
940:

Line 1032: INSERT INTO ZX_PRODUCT_OPTIONS_ALL (

1028: END LOOP;
1029: END LOOP;
1030:
1031: FORALL i in 1..nvl(pa_system_options.org_id.LAST,0)
1032: INSERT INTO ZX_PRODUCT_OPTIONS_ALL (
1033: PRODUCT_OPTIONS_ID,
1034: ORG_ID,
1035: APPLICATION_ID,
1036: DEF_OPTION_HIER_1_CODE,

Line 1062: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,

1058: LAST_UPDATE_DATE,
1059: LAST_UPDATED_BY,
1060: LAST_UPDATE_LOGIN
1061: )
1062: values (ZX_PRODUCT_OPTIONS_ALL_S.nextval,
1063: pa_system_options.org_id(i),
1064: 275, --application_id
1065: pa_system_options.DEFAULT_HIERARCHY1(i),
1066: pa_system_options.DEFAULT_HIERARCHY2(i),

Line 1121: INSERT INTO ZX_PRODUCT_OPTIONS_ALL (

1117: END IF;
1118:
1119: x_return_status := FND_API.G_RET_STS_SUCCESS;
1120:
1121: INSERT INTO ZX_PRODUCT_OPTIONS_ALL (
1122: PRODUCT_OPTIONS_ID,
1123: ORG_ID,
1124: APPLICATION_ID,
1125: EVENT_CLASS_MAPPING_ID,

Line 1153: SELECT ZX_PRODUCT_OPTIONS_ALL_S.nextval,

1149: LAST_UPDATE_DATE,
1150: LAST_UPDATED_BY,
1151: LAST_UPDATE_LOGIN
1152: )
1153: SELECT ZX_PRODUCT_OPTIONS_ALL_S.nextval,
1154: decode(l_multi_org_flag,'N',l_org_id,prd.org_id),
1155: prd.application_id,
1156: mapp.event_class_mapping_id,
1157: prd.def_option_hier_1_code,

Line 1183: FROM ZX_PRODUCT_OPTIONS_ALL prd,

1179: prd.created_by,
1180: prd.last_update_date,
1181: prd.last_updated_by,
1182: prd.last_update_login
1183: FROM ZX_PRODUCT_OPTIONS_ALL prd,
1184: ZX_EVNT_CLS_MAPPINGS mapp
1185: WHERE prd.application_id = 200
1186: AND prd.event_class_mapping_id is null
1187: AND mapp.application_id = prd.application_id

Line 1191: FROM ZX_PRODUCT_OPTIONS_ALL prd1

1187: AND mapp.application_id = prd.application_id
1188: AND mapp.entity_code = 'AP_INVOICES'
1189: AND mapp.event_class_code = 'EXPENSE REPORTS'
1190: AND NOT EXISTS (SELECT 1
1191: FROM ZX_PRODUCT_OPTIONS_ALL prd1
1192: WHERE prd1.ORG_ID = decode(l_multi_org_flag,'N',l_org_id,prd.org_id)
1193: AND prd1.APPLICATION_ID = 200
1194: AND prd1.event_class_mapping_id = (SELECT event_class_mapping_id
1195: FROM zx_evnt_cls_mappings