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.GMO_OC_TRANS_PKG dependencies on FND_LOOKUPS

Line 34: SELECT meaning from fnd_lookups where lookup_type = 'GMO_OC_OBJECT_LOV' and lookup_code = ob_type_id;

30: WHERE hou.organization_id = Plant
31: AND NVL(hou.date_to, SYSDATE+1) >= SYSDATE
32: and mp.organization_id = hou.organization_id;
33: CURSOR GET_OBJECT_TYPE(ob_type_id NUMBER) IS
34: SELECT meaning from fnd_lookups where lookup_type = 'GMO_OC_OBJECT_LOV' and lookup_code = ob_type_id;
35: CURSOR GET_OBJECT IS
36: select DECODE(object_type,1,
37: (select concatenated_segments from mtl_system_items_kfv where inventory_item_id = OBJECT_ID and organization_id = Plant),2,
38: (select resources from cr_rsrc_dtl where resource_id = OBJECT_ID),3,

Line 39: (select meaning from fnd_lookups where lookup_type = 'GMO_OC_TRANS_LOV' and lookup_code = OBJECT_ID),null) from dual;

35: CURSOR GET_OBJECT IS
36: select DECODE(object_type,1,
37: (select concatenated_segments from mtl_system_items_kfv where inventory_item_id = OBJECT_ID and organization_id = Plant),2,
38: (select resources from cr_rsrc_dtl where resource_id = OBJECT_ID),3,
39: (select meaning from fnd_lookups where lookup_type = 'GMO_OC_TRANS_LOV' and lookup_code = OBJECT_ID),null) from dual;
40: BEGIN
41: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CP : GENERATE_XML(OC) : START ');
42: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Input Parameter - Plant :'||Plant||' and Object Type:'||Object_type||' and Object_id :'||Object_id||' From Date :'||FromDate||' To Date :'||ToDate||' Operator_id:'||Operator_id);
43: l_from_date := null;

Line 77: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 1),2,

73: XMLTYPE(''''||:zz||''''))),
74: XMLAGG(XMLELEMENT("OPERATORCERTHEADER",
75: XMLFOREST(:orgName as OrganizationName ,
76: DECODE(oc_trans_hdr.TRANS_OBJECT_ID,1,
77: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 1),2,
78: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 2),3,
79: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 3),null) Transaction_Type,
80: DECODE(oc_trans_hdr.TRANS_OBJECT_ID,1,
81: (select concatenated_segments from mtl_system_items_kfv where inventory_item_id = oc_hdr.OBJECT_ID and organization_id = oc_hdr.ORGANIZATION_ID),2,

Line 78: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 2),3,

74: XMLAGG(XMLELEMENT("OPERATORCERTHEADER",
75: XMLFOREST(:orgName as OrganizationName ,
76: DECODE(oc_trans_hdr.TRANS_OBJECT_ID,1,
77: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 1),2,
78: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 2),3,
79: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 3),null) Transaction_Type,
80: DECODE(oc_trans_hdr.TRANS_OBJECT_ID,1,
81: (select concatenated_segments from mtl_system_items_kfv where inventory_item_id = oc_hdr.OBJECT_ID and organization_id = oc_hdr.ORGANIZATION_ID),2,
82: (select resources from cr_rsrc_dtl where resource_id = oc_hdr.OBJECT_ID),3,

Line 79: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 3),null) Transaction_Type,

75: XMLFOREST(:orgName as OrganizationName ,
76: DECODE(oc_trans_hdr.TRANS_OBJECT_ID,1,
77: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 1),2,
78: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 2),3,
79: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 3),null) Transaction_Type,
80: DECODE(oc_trans_hdr.TRANS_OBJECT_ID,1,
81: (select concatenated_segments from mtl_system_items_kfv where inventory_item_id = oc_hdr.OBJECT_ID and organization_id = oc_hdr.ORGANIZATION_ID),2,
82: (select resources from cr_rsrc_dtl where resource_id = oc_hdr.OBJECT_ID),3,
83: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_TRANS_LOV'' and lookup_code = oc_hdr.OBJECT_ID),null) Transaction_Object,

Line 83: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_TRANS_LOV'' and lookup_code = oc_hdr.OBJECT_ID),null) Transaction_Object,

79: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_OBJECT_LOV'' and lookup_code = 3),null) Transaction_Type,
80: DECODE(oc_trans_hdr.TRANS_OBJECT_ID,1,
81: (select concatenated_segments from mtl_system_items_kfv where inventory_item_id = oc_hdr.OBJECT_ID and organization_id = oc_hdr.ORGANIZATION_ID),2,
82: (select resources from cr_rsrc_dtl where resource_id = oc_hdr.OBJECT_ID),3,
83: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_TRANS_LOV'' and lookup_code = oc_hdr.OBJECT_ID),null) Transaction_Object,
84: DECODE(oc_trans_hdr.TRANS_OBJECT_ID,1,
85: (select description from mtl_system_items_kfv where inventory_item_id = oc_hdr.OBJECT_ID and organization_id = oc_hdr.ORGANIZATION_ID),2,
86: (select resource_desc from cr_rsrc_mst where resources IN (select resources from cr_rsrc_dtl where resource_id = oc_hdr.OBJECT_ID)),3,
87: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_TRANS_LOV'' and lookup_code = oc_hdr.OBJECT_ID),null) Object_Description,

Line 87: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_TRANS_LOV'' and lookup_code = oc_hdr.OBJECT_ID),null) Object_Description,

83: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_TRANS_LOV'' and lookup_code = oc_hdr.OBJECT_ID),null) Transaction_Object,
84: DECODE(oc_trans_hdr.TRANS_OBJECT_ID,1,
85: (select description from mtl_system_items_kfv where inventory_item_id = oc_hdr.OBJECT_ID and organization_id = oc_hdr.ORGANIZATION_ID),2,
86: (select resource_desc from cr_rsrc_mst where resources IN (select resources from cr_rsrc_dtl where resource_id = oc_hdr.OBJECT_ID)),3,
87: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_TRANS_LOV'' and lookup_code = oc_hdr.OBJECT_ID),null) Object_Description,
88: FND_MESSAGE.GET_STRING(oc_trans_hdr.user_key_label_product,oc_trans_hdr.USER_KEY_LABEL_TOKEN) User_Key_Label,
89: oc_trans_hdr.USER_KEY_VALUE User_Key_Value,
90: oc_trans_hdr.CREATION_DATE Transaction_Date,
91: oc_trans_hdr.USER_ID User_Id,

Line 101: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_QUAL_LOV'' and lookup_code =1),2,

97: ( SELECT XMLAGG(XMLELEMENT("OPER_CERT_DTL",XMLFOREST(DECODE(oc_trans_dtl.QUALIFICATION_TYPE,1,
98: (select unique(name) from OTA_CERTIFICATIONS_VL where certification_id = oc_trans_dtl.QUALIFICATION_ID),2,
99: (select unique(name) from per_competences where competence_id = oc_trans_dtl.QUALIFICATION_ID),null) Qualification,
100: DECODE(oc_trans_dtl.QUALIFICATION_TYPE,1,
101: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_QUAL_LOV'' and lookup_code =1),2,
102: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_QUAL_LOV'' and lookup_code =2),null) Qualification_type,
103: DECODE(oc_trans_dtl.QUALIFICATION_TYPE,2,
104: (select step_value||''-''||name from per_rating_levels where rating_level_id = oc_trans_dtl.PROFICIENCY_LEVEL_ID),null) Proficiency_Level )))
105: FROM GMO_OPERATOR_TRANS_DETAIL oc_trans_dtl

Line 102: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_QUAL_LOV'' and lookup_code =2),null) Qualification_type,

98: (select unique(name) from OTA_CERTIFICATIONS_VL where certification_id = oc_trans_dtl.QUALIFICATION_ID),2,
99: (select unique(name) from per_competences where competence_id = oc_trans_dtl.QUALIFICATION_ID),null) Qualification,
100: DECODE(oc_trans_dtl.QUALIFICATION_TYPE,1,
101: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_QUAL_LOV'' and lookup_code =1),2,
102: (select meaning from fnd_lookups where lookup_type = ''GMO_OC_QUAL_LOV'' and lookup_code =2),null) Qualification_type,
103: DECODE(oc_trans_dtl.QUALIFICATION_TYPE,2,
104: (select step_value||''-''||name from per_rating_levels where rating_level_id = oc_trans_dtl.PROFICIENCY_LEVEL_ID),null) Proficiency_Level )))
105: FROM GMO_OPERATOR_TRANS_DETAIL oc_trans_dtl
106: WHERE oc_trans_dtl.OPERATOR_CERTIFICATE_ID = oc_trans_hdr.OPERATOR_CERTIFICATE_ID