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.

[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on EGO_RESULTS_FMT_USAGES

Line 1095: FROM ego_results_fmt_usages

1091: -- To get the Item Base attr columns in the Result Format.
1092: ---------------------------------------------------------------
1093: CURSOR c_item_base_attr_intf_cols (c_resultfmt_usage_id IN NUMBER) IS
1094: SELECT attribute_code, intf_column_name
1095: FROM ego_results_fmt_usages
1096: WHERE resultfmt_usage_id = c_resultfmt_usage_id
1097: AND attribute_code NOT LIKE '%$$%'
1098: AND attribute_code <> 'APPROVAL_STATUS' -- bug: 3433942
1099: AND attribute_code NOT IN ('SUPPLIER_NAME','SUPPLIER_SITE','SUPPLIER_PRIMARY','SUPPLIER_STATUS','SUPPLIERSITE_STATUS'

Line 3301: FROM ego_results_fmt_usages

3297: ------------------------------------------------------------------------------------------
3298: CURSOR c_item_rev_attr_intf_cols (c_resultfmt_usage_id IN NUMBER) IS
3299: --Item Revision Data Level
3300: SELECT attribute_code, intf_column_name
3301: FROM ego_results_fmt_usages
3302: WHERE resultfmt_usage_id = c_resultfmt_usage_id
3303: AND attribute_code NOT LIKE '%$$%'
3304: ---------------------------------------------------------------------------
3305: -- Added NOT LIKE 'GTIN_%' to filter out Dummy Attrs for Attr Group: "GTIN"

Line 3314: FROM ego_results_fmt_usages

3310: -------------------
3311: --Item Data Level
3312: -------------------
3313: SELECT attribute_code, intf_column_name
3314: FROM ego_results_fmt_usages
3315: WHERE resultfmt_usage_id = c_resultfmt_usage_id
3316: AND attribute_code NOT LIKE '%$$%'
3317: ---------------------------------------------------------------------------
3318: -- Added NOT LIKE 'GTIN_%' to filter out Dummy Attrs for Attr Group: "GTIN"

Line 4313: FROM ego_results_fmt_usages

4309: -- To retrieve Attribute group codes, for given Result Format Usage ID.
4310: ------------------------------------------------------------------------------
4311: CURSOR c_user_attr_group_codes (c_resultfmt_usage_id IN NUMBER) IS
4312: SELECT DISTINCT To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) attr_group_id
4313: FROM ego_results_fmt_usages
4314: WHERE resultfmt_usage_id = c_resultfmt_usage_id
4315: AND attribute_code LIKE '%$$%'
4316: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN --attr_group_id
4317: ------------------------------------------------------------------------------

Line 4523: FROM EGO_RESULTS_FMT_USAGES

4519:
4520: BEGIN
4521: SELECT INTF_COLUMN_NAME
4522: INTO l_supplier_name_col
4523: FROM EGO_RESULTS_FMT_USAGES
4524: WHERE RESULTFMT_USAGE_ID = p_resultfmt_usage_id
4525: AND ATTRIBUTE_CODE NOT LIKE '%$$%'
4526: AND CUSTOMIZATION_APPLICATION_ID = 431
4527: AND REGION_APPLICATION_ID = 431

Line 4537: FROM EGO_RESULTS_FMT_USAGES

4533:
4534: BEGIN
4535: SELECT INTF_COLUMN_NAME
4536: INTO l_supplier_number_col
4537: FROM EGO_RESULTS_FMT_USAGES
4538: WHERE RESULTFMT_USAGE_ID = p_resultfmt_usage_id
4539: AND ATTRIBUTE_CODE NOT LIKE '%$$%'
4540: AND CUSTOMIZATION_APPLICATION_ID = 431
4541: AND REGION_APPLICATION_ID = 431

Line 4551: FROM EGO_RESULTS_FMT_USAGES

4547:
4548: BEGIN
4549: SELECT INTF_COLUMN_NAME
4550: INTO l_supplier_site_name_col
4551: FROM EGO_RESULTS_FMT_USAGES
4552: WHERE RESULTFMT_USAGE_ID = p_resultfmt_usage_id
4553: AND ATTRIBUTE_CODE NOT LIKE '%$$%'
4554: AND CUSTOMIZATION_APPLICATION_ID = 431
4555: AND REGION_APPLICATION_ID = 431

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

4586: --- R12C UOM Change. Removing to_Num conversion . Now attrId$$UOM will also go into l_attr_id_table
4587: -- old code l_dyn_sql := ' SELECT To_Number(SUBSTR(attribute_code, INSTR(attribute_code, ''$$'')+2)) attr_id, intf_column_name, DATA_LEVEL_ID ';
4588:
4589: l_dyn_sql := ' SELECT SUBSTR(attribute_code, INSTR(attribute_code, ''$$'')+2) attr_id, intf_column_name, DATA_LEVEL_ID ';
4590: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';
4591: l_dyn_sql := l_dyn_sql || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID';
4592: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
4593: l_dyn_sql := l_dyn_sql || ' ORDER BY DISPLAY_SEQUENCE '; --- R12C UOM Change.so that UOM col comes next to corresponding number col
4594:

Line 5271: FROM ego_results_fmt_usages

5267: -- To get the count of Item Operational Attr Groups Result Format. --
5268: ------------------------------------------------------------------------
5269: CURSOR c_item_oper_attr_grp_count (c_resultfmt_usage_id IN NUMBER) IS
5270: SELECT count(distinct(To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1))))
5271: FROM ego_results_fmt_usages
5272: WHERE resultfmt_usage_id = c_resultfmt_usage_id
5273: AND attribute_code LIKE '%$$%'
5274: -- Following statement fetches the Attribute Group Id --
5275: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN

Line 5288: FROM ego_results_fmt_usages

5284: -- To get the Item Operational Attr Groups in the Result Format. --
5285: ------------------------------------------------------------------------
5286: CURSOR c_item_oper_attr_grp_ids (c_resultfmt_usage_id IN NUMBER) IS
5287: SELECT distinct(To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1))) OPER_ATTR_GRP_ID
5288: FROM ego_results_fmt_usages
5289: WHERE resultfmt_usage_id = c_resultfmt_usage_id
5290: AND attribute_code LIKE '%$$%'
5291: -- Following statement fetches the Attribute Group Id --
5292: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN

Line 5309: FROM ego_results_fmt_usages

5305: ) IS
5306: -- First column is the Attibute Id --
5307: SELECT To_Number(SUBSTR(attribute_code, INSTR(attribute_code, '$$')+2))
5308: , intf_column_name
5309: FROM ego_results_fmt_usages
5310: WHERE resultfmt_usage_id = c_resultfmt_usage_id
5311: AND INSTR(attribute_code, '$$UOM') = 0 -- R12C UOM Change : ignoring uom columns in this case:
5312: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) = c_attr_group_id;
5313:

Line 5317: || ' FROM ego_results_fmt_usages '

5313:
5314: l_item_oper_attr_sql VARCHAR2(1000) :=
5315: ' SELECT To_Number(SUBSTR(attribute_code, INSTR(attribute_code, ''$$'')+2)) '
5316: || ' , intf_column_name '
5317: || ' FROM ego_results_fmt_usages '
5318: || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID '
5319: || ' AND INSTR(attribute_code, ''$$UOM'') = 0 ' -- R12C UOM Change : ignoring uom columns in this case:
5320: || ' AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, ''$$'') - 1)) = :ATTR_GROUP_ID ';
5321:

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

6024: CURSOR c_resultfmt_info (c_resultfmt_usage_id IN NUMBER) IS
6025: SELECT Nvl(fmt.data_level, G_ITEM_DATA_LEVEL)
6026: ---------------------------------------------------------------------------------
6027: --Fix for Bug# 3681711. (JCGEORGE)
6028: -- CLASSIFICATION_CODE in EGO_RESULTS_FMT_USAGES, now stores the **current**
6029: -- Item Catalog Group ID for the selected Import Format.
6030: ---------------------------------------------------------------------------------
6031: --, Decode(fmt.classification1, -1, NULL, fmt.classification1)
6032: , Decode(fmt_usg.classification_code, -1, NULL, fmt_usg.classification_code)

Line 6033: FROM ego_results_fmt_usages fmt_usg, ego_results_format_v fmt

6029: -- Item Catalog Group ID for the selected Import Format.
6030: ---------------------------------------------------------------------------------
6031: --, Decode(fmt.classification1, -1, NULL, fmt.classification1)
6032: , Decode(fmt_usg.classification_code, -1, NULL, fmt_usg.classification_code)
6033: FROM ego_results_fmt_usages fmt_usg, ego_results_format_v fmt
6034: WHERE fmt_usg.resultfmt_usage_id = c_resultfmt_usage_id
6035: AND fmt.customization_application_id = fmt_usg.customization_application_id
6036: AND fmt.customization_code = fmt_usg.customization_code
6037: AND fmt.region_application_id = fmt_usg.region_application_id

Line 6042: FROM ego_results_fmt_usages

6038: AND fmt.region_code = fmt_usg.region_code;
6039:
6040: CURSOR c_revision_code_exists (c_resultfmt_usage_id IN NUMBER) IS
6041: SELECT 'x'
6042: FROM ego_results_fmt_usages
6043: WHERE resultfmt_usage_id = c_resultfmt_usage_id
6044: AND attribute_code = G_REV_CODE_ATTR_CODE;
6045:
6046: CURSOR c_mtl_intf_err_row_exists IS

Line 6208: FROM ego_results_fmt_usages

6204: -------------------------------------------------------------------
6205:
6206: SELECT count(*)
6207: INTO l_rev_base_attrs_count
6208: FROM ego_results_fmt_usages
6209: WHERE resultfmt_usage_id = p_resultfmt_usage_id
6210: AND attribute_code NOT LIKE '%$$%'
6211: ---------------------------------------------------------------------------
6212: -- Added NOT LIKE 'GTIN_%' to filter out Dummy Attrs for Attr Group: "GTIN"

Line 7256: FROM ego_results_fmt_usages

7252: -- To get the Item intersection attr columns in the Result Format.
7253: ------------------------------------------------------------------------------------------
7254: CURSOR c_item_intersection_intf_cols (c_resultfmt_usage_id IN NUMBER) IS
7255: SELECT attribute_code, intf_column_name, data_level_id
7256: FROM ego_results_fmt_usages
7257: WHERE resultfmt_usage_id = c_resultfmt_usage_id
7258: /* AND DATA_LEVEL_ID in (SELECT DATA_LEVEL_ID
7259: FROM EGO_DATA_LEVEL_B
7260: WHERE DATA_LEVEL_NAME IN ('ITEM_SUP','ITEM_ORG','ITEM_SUP_SITE')