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

Line 1132: FROM ego_results_fmt_usages

1128: -- To get the Item Base attr columns in the Result Format.
1129: ---------------------------------------------------------------
1130: CURSOR c_item_base_attr_intf_cols (c_resultfmt_usage_id IN NUMBER) IS
1131: SELECT attribute_code, intf_column_name
1132: FROM ego_results_fmt_usages
1133: WHERE resultfmt_usage_id = c_resultfmt_usage_id
1134: AND attribute_code NOT LIKE '%$$%'
1135: AND attribute_code <> 'APPROVAL_STATUS' -- bug: 3433942
1136: AND attribute_code <> 'MASTER_ORGANIZATION_ID' -- bug: 8347241

Line 3386: FROM ego_results_fmt_usages

3382: ------------------------------------------------------------------------------------------
3383: CURSOR c_item_rev_attr_intf_cols (c_resultfmt_usage_id IN NUMBER) IS
3384: --Item Revision Data Level
3385: SELECT attribute_code, intf_column_name
3386: FROM ego_results_fmt_usages
3387: WHERE resultfmt_usage_id = c_resultfmt_usage_id
3388: AND attribute_code NOT LIKE '%$$%'
3389: ---------------------------------------------------------------------------
3390: -- Added NOT LIKE 'GTIN_%' to filter out Dummy Attrs for Attr Group: "GTIN"

Line 3399: FROM ego_results_fmt_usages

3395: -------------------
3396: --Item Data Level
3397: -------------------
3398: SELECT attribute_code, intf_column_name
3399: FROM ego_results_fmt_usages
3400: WHERE resultfmt_usage_id = c_resultfmt_usage_id
3401: AND attribute_code NOT LIKE '%$$%'
3402: ---------------------------------------------------------------------------
3403: -- Added NOT LIKE 'GTIN_%' to filter out Dummy Attrs for Attr Group: "GTIN"

Line 4398: FROM ego_results_fmt_usages

4394: -- To retrieve Attribute group codes, for given Result Format Usage ID.
4395: ------------------------------------------------------------------------------
4396: CURSOR c_user_attr_group_codes (c_resultfmt_usage_id IN NUMBER) IS
4397: SELECT DISTINCT To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) attr_group_id
4398: FROM ego_results_fmt_usages
4399: WHERE resultfmt_usage_id = c_resultfmt_usage_id
4400: AND attribute_code LIKE '%$$%'
4401: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN --attr_group_id
4402: ------------------------------------------------------------------------------

Line 4608: FROM EGO_RESULTS_FMT_USAGES

4604:
4605: BEGIN
4606: SELECT INTF_COLUMN_NAME
4607: INTO l_supplier_name_col
4608: FROM EGO_RESULTS_FMT_USAGES
4609: WHERE RESULTFMT_USAGE_ID = p_resultfmt_usage_id
4610: AND ATTRIBUTE_CODE NOT LIKE '%$$%'
4611: AND CUSTOMIZATION_APPLICATION_ID = 431
4612: AND REGION_APPLICATION_ID = 431

Line 4622: FROM EGO_RESULTS_FMT_USAGES

4618:
4619: BEGIN
4620: SELECT INTF_COLUMN_NAME
4621: INTO l_supplier_number_col
4622: FROM EGO_RESULTS_FMT_USAGES
4623: WHERE RESULTFMT_USAGE_ID = p_resultfmt_usage_id
4624: AND ATTRIBUTE_CODE NOT LIKE '%$$%'
4625: AND CUSTOMIZATION_APPLICATION_ID = 431
4626: AND REGION_APPLICATION_ID = 431

Line 4636: FROM EGO_RESULTS_FMT_USAGES

4632:
4633: BEGIN
4634: SELECT INTF_COLUMN_NAME
4635: INTO l_supplier_site_name_col
4636: FROM EGO_RESULTS_FMT_USAGES
4637: WHERE RESULTFMT_USAGE_ID = p_resultfmt_usage_id
4638: AND ATTRIBUTE_CODE NOT LIKE '%$$%'
4639: AND CUSTOMIZATION_APPLICATION_ID = 431
4640: AND REGION_APPLICATION_ID = 431

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

4671: --- R12C UOM Change. Removing to_Num conversion . Now attrId$$UOM will also go into l_attr_id_table
4672: -- old code l_dyn_sql := ' SELECT To_Number(SUBSTR(attribute_code, INSTR(attribute_code, ''$$'')+2)) attr_id, intf_column_name, DATA_LEVEL_ID ';
4673:
4674: l_dyn_sql := ' SELECT SUBSTR(attribute_code, INSTR(attribute_code, ''$$'')+2) attr_id, intf_column_name, DATA_LEVEL_ID ';
4675: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';
4676: l_dyn_sql := l_dyn_sql || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID';
4677: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
4678: l_dyn_sql := l_dyn_sql || ' ORDER BY DISPLAY_SEQUENCE '; --- R12C UOM Change.so that UOM col comes next to corresponding number col
4679:

Line 5361: FROM ego_results_fmt_usages

5357: -- To get the count of Item Operational Attr Groups Result Format. --
5358: ------------------------------------------------------------------------
5359: CURSOR c_item_oper_attr_grp_count (c_resultfmt_usage_id IN NUMBER) IS
5360: SELECT count(distinct(To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1))))
5361: FROM ego_results_fmt_usages
5362: WHERE resultfmt_usage_id = c_resultfmt_usage_id
5363: AND attribute_code LIKE '%$$%'
5364: -- Following statement fetches the Attribute Group Id --
5365: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN

Line 5378: FROM ego_results_fmt_usages

5374: -- To get the Item Operational Attr Groups in the Result Format. --
5375: ------------------------------------------------------------------------
5376: CURSOR c_item_oper_attr_grp_ids (c_resultfmt_usage_id IN NUMBER) IS
5377: SELECT distinct(To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1))) OPER_ATTR_GRP_ID
5378: FROM ego_results_fmt_usages
5379: WHERE resultfmt_usage_id = c_resultfmt_usage_id
5380: AND attribute_code LIKE '%$$%'
5381: -- Following statement fetches the Attribute Group Id --
5382: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN

Line 5399: FROM ego_results_fmt_usages

5395: ) IS
5396: -- First column is the Attibute Id --
5397: SELECT To_Number(SUBSTR(attribute_code, INSTR(attribute_code, '$$')+2))
5398: , intf_column_name
5399: FROM ego_results_fmt_usages
5400: WHERE resultfmt_usage_id = c_resultfmt_usage_id
5401: AND INSTR(attribute_code, '$$UOM') = 0 -- R12C UOM Change : ignoring uom columns in this case:
5402: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) = c_attr_group_id;
5403:

Line 5407: || ' FROM ego_results_fmt_usages '

5403:
5404: l_item_oper_attr_sql VARCHAR2(1000) :=
5405: ' SELECT To_Number(SUBSTR(attribute_code, INSTR(attribute_code, ''$$'')+2)) '
5406: || ' , intf_column_name '
5407: || ' FROM ego_results_fmt_usages '
5408: || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID '
5409: || ' AND INSTR(attribute_code, ''$$UOM'') = 0 ' -- R12C UOM Change : ignoring uom columns in this case:
5410: || ' AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, ''$$'') - 1)) = :ATTR_GROUP_ID ';
5411:

Line 6181: -- CLASSIFICATION_CODE in EGO_RESULTS_FMT_USAGES, now stores the current

6177: CURSOR c_resultfmt_info (c_resultfmt_usage_id IN NUMBER) IS
6178: SELECT Nvl(fmt.data_level, G_ITEM_DATA_LEVEL)
6179: ---------------------------------------------------------------------------------
6180: --Fix for Bug# 3681711. (JCGEORGE)
6181: -- CLASSIFICATION_CODE in EGO_RESULTS_FMT_USAGES, now stores the **current**
6182: -- Item Catalog Group ID for the selected Import Format.
6183: ---------------------------------------------------------------------------------
6184: --, Decode(fmt.classification1, -1, NULL, fmt.classification1)
6185: , Decode(fmt_usg.classification_code, -1, NULL, fmt_usg.classification_code)

Line 6186: FROM ego_results_fmt_usages fmt_usg, ego_results_format_v fmt

6182: -- Item Catalog Group ID for the selected Import Format.
6183: ---------------------------------------------------------------------------------
6184: --, Decode(fmt.classification1, -1, NULL, fmt.classification1)
6185: , Decode(fmt_usg.classification_code, -1, NULL, fmt_usg.classification_code)
6186: FROM ego_results_fmt_usages fmt_usg, ego_results_format_v fmt
6187: WHERE fmt_usg.resultfmt_usage_id = c_resultfmt_usage_id
6188: AND fmt.customization_application_id = fmt_usg.customization_application_id
6189: AND fmt.customization_code = fmt_usg.customization_code
6190: AND fmt.region_application_id = fmt_usg.region_application_id

Line 6195: FROM ego_results_fmt_usages

6191: AND fmt.region_code = fmt_usg.region_code;
6192:
6193: CURSOR c_revision_code_exists (c_resultfmt_usage_id IN NUMBER) IS
6194: SELECT 'x'
6195: FROM ego_results_fmt_usages
6196: WHERE resultfmt_usage_id = c_resultfmt_usage_id
6197: AND attribute_code = G_REV_CODE_ATTR_CODE;
6198:
6199: CURSOR c_mtl_intf_err_row_exists IS

Line 6361: FROM ego_results_fmt_usages

6357: -------------------------------------------------------------------
6358:
6359: SELECT count(*)
6360: INTO l_rev_base_attrs_count
6361: FROM ego_results_fmt_usages
6362: WHERE resultfmt_usage_id = p_resultfmt_usage_id
6363: AND attribute_code NOT LIKE '%$$%'
6364: ---------------------------------------------------------------------------
6365: -- Added NOT LIKE 'GTIN_%' to filter out Dummy Attrs for Attr Group: "GTIN"

Line 7409: FROM ego_results_fmt_usages

7405: -- To get the Item intersection attr columns in the Result Format.
7406: ------------------------------------------------------------------------------------------
7407: CURSOR c_item_intersection_intf_cols (c_resultfmt_usage_id IN NUMBER) IS
7408: SELECT attribute_code, intf_column_name, data_level_id
7409: FROM ego_results_fmt_usages
7410: WHERE resultfmt_usage_id = c_resultfmt_usage_id
7411: /* AND DATA_LEVEL_ID in (SELECT DATA_LEVEL_ID
7412: FROM EGO_DATA_LEVEL_B
7413: WHERE DATA_LEVEL_NAME IN ('ITEM_SUP','ITEM_ORG','ITEM_SUP_SITE')