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.BOM_BULKLOAD_PVT_PKG dependencies on EGO_RESULTS_FMT_USAGES

Line 691: Ego_Results_Fmt_Usages erf,

687: bcc.Bom_Intf_Table_Name,
688: bcc.Operation_Type,
689: bcc.Lookup_Type
690: FROM
691: Ego_Results_Fmt_Usages erf,
692: Bom_Component_Columns bcc
693: WHERE
694: (Region_Code = 'BOM_RESULT_DUMMY_REGION'
695: OR -- Fix for import Region

Line 788: -- Getting the Intf_column names from the ego_results_fmt_usages for the attributes

784: FND_FILE.PUT_LINE( FND_FILE.LOG,'No Rows to Process for Data Separation' );
785: return;
786: end if;
787:
788: -- Getting the Intf_column names from the ego_results_fmt_usages for the attributes
789: -- of OrgCode and CompSeqId. Previously we hard-coding them
790: IF l_debug = 'Y' THEN
791: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE before :--->' || G_INTF_ORG_CODE);
792: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID before :--->' || G_INTF_COMP_SEQ_ID);

Line 798: Select INTF_COLUMN_NAME into G_INTF_ORG_CODE FROM Ego_Results_Fmt_Usages erf

794: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION before :--->' || G_INTF_PARENT_REVISION);
795: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION before :--->' || G_INTF_REVISION);
796: END IF;
797:
798: Select INTF_COLUMN_NAME into G_INTF_ORG_CODE FROM Ego_Results_Fmt_Usages erf
799: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'ORGANIZATION_CODE';
800:
801: BEGIN -- In imort formats may not be having the attribute ComponentSequenceId
802: Select INTF_COLUMN_NAME into G_INTF_COMP_SEQ_ID FROM Ego_Results_Fmt_Usages erf

Line 802: Select INTF_COLUMN_NAME into G_INTF_COMP_SEQ_ID FROM Ego_Results_Fmt_Usages erf

798: Select INTF_COLUMN_NAME into G_INTF_ORG_CODE FROM Ego_Results_Fmt_Usages erf
799: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'ORGANIZATION_CODE';
800:
801: BEGIN -- In imort formats may not be having the attribute ComponentSequenceId
802: Select INTF_COLUMN_NAME into G_INTF_COMP_SEQ_ID FROM Ego_Results_Fmt_Usages erf
803: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'COMPONENT_SEQUENCE_ID';
804: EXCEPTION
805: WHEN NO_DATA_FOUND THEN
806: G_INTF_COMP_SEQ_ID := 'NULL';

Line 810: Select INTF_COLUMN_NAME into G_INTF_ASSEMBLY_TYPE FROM Ego_Results_Fmt_Usages erf

806: G_INTF_COMP_SEQ_ID := 'NULL';
807: END;
808:
809: BEGIN
810: Select INTF_COLUMN_NAME into G_INTF_ASSEMBLY_TYPE FROM Ego_Results_Fmt_Usages erf
811: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'SUB_ASSEMBLY_TYPE';
812: EXCEPTION
813: WHEN NO_DATA_FOUND THEN
814: G_INTF_ASSEMBLY_TYPE := 'NULL';

Line 818: Select INTF_COLUMN_NAME into G_INTF_PARENT_REVISION FROM Ego_Results_Fmt_Usages erf

814: G_INTF_ASSEMBLY_TYPE := 'NULL';
815: END;
816:
817: BEGIN
818: Select INTF_COLUMN_NAME into G_INTF_PARENT_REVISION FROM Ego_Results_Fmt_Usages erf
819: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'PARENT_REVISION_CODE';
820: EXCEPTION
821: WHEN NO_DATA_FOUND THEN
822: G_INTF_PARENT_REVISION := 'NULL';

Line 826: Select INTF_COLUMN_NAME into G_INTF_REVISION FROM Ego_Results_Fmt_Usages erf

822: G_INTF_PARENT_REVISION := 'NULL';
823: END;
824:
825: BEGIN
826: Select INTF_COLUMN_NAME into G_INTF_REVISION FROM Ego_Results_Fmt_Usages erf
827: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'REVISION';
828: EXCEPTION
829: WHEN NO_DATA_FOUND THEN
830: G_INTF_REVISION := 'NULL';

Line 854: Select INTF_COLUMN_NAME into G_INTF_REF_DESIG FROM Ego_Results_Fmt_Usages erf

850: END IF;
851: --bug 13829520 end
852:
853: BEGIN -- In imort formats may not be having the attribute COMPONENT_REFERENCE_DESIGNATOR
854: Select INTF_COLUMN_NAME into G_INTF_REF_DESIG FROM Ego_Results_Fmt_Usages erf
855: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'COMPONENT_REFERENCE_DESIGNATOR';
856: EXCEPTION
857: WHEN NO_DATA_FOUND THEN
858: G_INTF_REF_DESIG := 'NULL';

Line 2011: FROM ego_results_fmt_usages

2007: -- To retrieve Attribute group codes, for given Result Format Usage ID.
2008: ------------------------------------------------------------------------------
2009: CURSOR c_user_attr_group_codes (c_resultfmt_usage_id IN NUMBER) IS
2010: SELECT DISTINCT To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) attr_group_id
2011: FROM ego_results_fmt_usages
2012: WHERE resultfmt_usage_id = c_resultfmt_usage_id
2013: AND attribute_code LIKE '%$$%'
2014: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN --attr_group_id
2015: ------------------------------------------------------------------------------

Line 2190: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';

2186: -- Fetch Organization ID, Item Number in Temp PLSQL tables.
2187: --------------------------------------------------------------------
2188: l_dyn_sql := '';
2189: l_dyn_sql := ' SELECT To_Number(SUBSTR(attribute_code, INSTR(attribute_code, ''$$'')+2)) attr_id, intf_column_name ';
2190: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';
2191: l_dyn_sql := l_dyn_sql || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID';
2192: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
2193: -- P4T Bug 8371175 start
2194: l_dyn_sql := l_dyn_sql || ' AND attribute_code NOT LIKE :ATTRIBUTE_CODE_O ';