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_IMPORT_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 590: l_seq_name MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_SEQ_NAME%TYPE;

586: * Method to get next item number for a sequence generated item
587: * This method is only for use in Resolve_Child_Entities
588: */
589: FUNCTION GET_NEXT_ITEM_NUMBER(p_catalog_group_id NUMBER) RETURN VARCHAR2 AS
590: l_seq_name MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_SEQ_NAME%TYPE;
591: l_prefix MTL_ITEM_CATALOG_GROUPS_B.PREFIX%TYPE;
592: l_suffix MTL_ITEM_CATALOG_GROUPS_B.SUFFIX%TYPE;
593: l_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
594: l_item_number VARCHAR2(2000);

Line 591: l_prefix MTL_ITEM_CATALOG_GROUPS_B.PREFIX%TYPE;

587: * This method is only for use in Resolve_Child_Entities
588: */
589: FUNCTION GET_NEXT_ITEM_NUMBER(p_catalog_group_id NUMBER) RETURN VARCHAR2 AS
590: l_seq_name MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_SEQ_NAME%TYPE;
591: l_prefix MTL_ITEM_CATALOG_GROUPS_B.PREFIX%TYPE;
592: l_suffix MTL_ITEM_CATALOG_GROUPS_B.SUFFIX%TYPE;
593: l_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
594: l_item_number VARCHAR2(2000);
595: l_sql VARCHAR2(2000);

Line 592: l_suffix MTL_ITEM_CATALOG_GROUPS_B.SUFFIX%TYPE;

588: */
589: FUNCTION GET_NEXT_ITEM_NUMBER(p_catalog_group_id NUMBER) RETURN VARCHAR2 AS
590: l_seq_name MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_SEQ_NAME%TYPE;
591: l_prefix MTL_ITEM_CATALOG_GROUPS_B.PREFIX%TYPE;
592: l_suffix MTL_ITEM_CATALOG_GROUPS_B.SUFFIX%TYPE;
593: l_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
594: l_item_number VARCHAR2(2000);
595: l_sql VARCHAR2(2000);
596: BEGIN

Line 593: l_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;

589: FUNCTION GET_NEXT_ITEM_NUMBER(p_catalog_group_id NUMBER) RETURN VARCHAR2 AS
590: l_seq_name MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_SEQ_NAME%TYPE;
591: l_prefix MTL_ITEM_CATALOG_GROUPS_B.PREFIX%TYPE;
592: l_suffix MTL_ITEM_CATALOG_GROUPS_B.SUFFIX%TYPE;
593: l_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
594: l_item_number VARCHAR2(2000);
595: l_sql VARCHAR2(2000);
596: BEGIN
597: SELECT ITEM_NUM_SEQ_NAME, PREFIX, SUFFIX, ITEM_NUM_GEN_METHOD

Line 602: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

598: INTO l_seq_name, l_prefix, l_suffix, l_gen_method
599: FROM
600: (
601: SELECT ICC.ITEM_NUM_SEQ_NAME, ICC.PREFIX, ICC.SUFFIX, ICC.ITEM_NUM_GEN_METHOD
602: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
603: WHERE ICC.ITEM_NUM_GEN_METHOD IS NOT NULL
604: AND ICC.ITEM_NUM_GEN_METHOD <> 'I'
605: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
606: START WITH ICC.ITEM_CATALOG_GROUP_ID = p_catalog_group_id

Line 6197: l_item_num_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;

6193: l_pdh_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
6194: l_pdh_description MTL_SYSTEM_ITEMS_INTERFACE.DESCRIPTION%TYPE;
6195: l_pdh_item_catalog_group_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
6196: l_confirm_status MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE;
6197: l_item_num_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6198: l_item_desc_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6199: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6200: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6201: l_batch_rev_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;

Line 6198: l_item_desc_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;

6194: l_pdh_description MTL_SYSTEM_ITEMS_INTERFACE.DESCRIPTION%TYPE;
6195: l_pdh_item_catalog_group_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
6196: l_confirm_status MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE;
6197: l_item_num_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6198: l_item_desc_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6199: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6200: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6201: l_batch_rev_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
6202: l_instance_rev_policy MTL_SYSTEM_ITEMS_INTERFACE.REVISION_IMPORT_POLICY%TYPE;

Line 6230: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG

6226: ATTR.ENABLED_FLAG = 'Y' AND
6227: ATTR.ATTRIBUTE_NAME LIKE 'MTL_SYSTEM_ITEMS.DESCRIPTION')),
6228: NVL(ITEM_CATALOG_GROUP_ID,
6229: ( SELECT MICG.ITEM_CATALOG_GROUP_ID
6230: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG
6231: WHERE MICG.CONCATENATED_SEGMENTS = MSII.ITEM_CATALOG_GROUP_NAME)),
6232: CONFIRM_STATUS,
6233: NVL(REVISION_IMPORT_POLICY, l_batch_rev_policy),
6234: MSII.STYLE_ITEM_FLAG

Line 6310: l_item_num_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;

6306: x_item_num_gen_method OUT NOCOPY VARCHAR2,
6307: x_item_desc_gen_method OUT NOCOPY VARCHAR2) IS
6308: l_num_gen_resolved VARCHAR2(1) := 'N';
6309: l_desc_gen_resolved VARCHAR2(1) := 'N';
6310: l_item_num_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6311: l_item_desc_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6312:
6313: CURSOR c_gen_method IS
6314: SELECT

Line 6311: l_item_desc_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;

6307: x_item_desc_gen_method OUT NOCOPY VARCHAR2) IS
6308: l_num_gen_resolved VARCHAR2(1) := 'N';
6309: l_desc_gen_resolved VARCHAR2(1) := 'N';
6310: l_item_num_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6311: l_item_desc_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6312:
6313: CURSOR c_gen_method IS
6314: SELECT
6315: DECODE(ICC.ITEM_NUM_GEN_METHOD,

Line 6321: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

6317: ICC.ITEM_NUM_GEN_METHOD),
6318: DECODE(ICC.ITEM_DESC_GEN_METHOD,
6319: NULL, DECODE(ICC.PARENT_CATALOG_GROUP_ID, NULL, 'U', 'I'),
6320: ICC.ITEM_DESC_GEN_METHOD)
6321: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
6322: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
6323: START WITH ICC.ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id;
6324: BEGIN
6325: OPEN c_gen_method;

Line 7471: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG

7467: -- update the item_catalog_group_id
7468: UPDATE
7469: MTL_SYSTEM_ITEMS_INTERFACE MSII
7470: SET ITEM_CATALOG_GROUP_ID = (SELECT MICG.ITEM_CATALOG_GROUP_ID
7471: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG
7472: WHERE MICG.CONCATENATED_SEGMENTS = MSII.ITEM_CATALOG_GROUP_NAME)
7473: WHERE MSII.SET_PROCESS_ID = p_data_set_id
7474: AND MSII.PROCESS_FLAG = 0
7475: AND MSII.ORGANIZATION_ID = l_org_id

Line 8338: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

8334: AND ATTR.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DESCRIPTION'
8335: )
8336: AND 'F' <>
8337: (SELECT DECODE(MSII.STYLE_ITEM_FLAG, 'Y', 'ZZZ', (MAX(ICC.ITEM_DESC_GEN_METHOD) KEEP (DENSE_RANK FIRST ORDER BY LEVEL) ) ) AS ITEM_DESC_GEN_METHOD
8338: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
8339: WHERE ICC.ITEM_DESC_GEN_METHOD IS NOT NULL
8340: AND ICC.ITEM_DESC_GEN_METHOD <> 'I'
8341: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
8342: START WITH ICC.ITEM_CATALOG_GROUP_ID = MSII.ITEM_CATALOG_GROUP_ID

Line 8353: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

8349: WHEN
8350: ( MSII.ITEM_CATALOG_GROUP_ID IS NOT NULL
8351: AND MSII.ITEM_NUMBER IS NULL
8352: AND (SELECT DECODE(MSII.STYLE_ITEM_FLAG, 'Y', 'ZZZ', (MAX(ICC.ITEM_NUM_GEN_METHOD) KEEP (DENSE_RANK FIRST ORDER BY LEVEL) ) ) AS ITEM_NUM_GEN_METHOD
8353: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
8354: WHERE ICC.ITEM_NUM_GEN_METHOD IS NOT NULL
8355: AND ICC.ITEM_NUM_GEN_METHOD <> 'I'
8356: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
8357: START WITH ICC.ITEM_CATALOG_GROUP_ID = MSII.ITEM_CATALOG_GROUP_ID

Line 8393: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

8389: AND MSII.PROCESS_FLAG = 0
8390: AND MSII.CONFIRM_STATUS = 'CNR'
8391: AND MSII.ORGANIZATION_ID = l_org_id
8392: AND 'S' = ( SELECT MAX( ICC.ITEM_NUM_GEN_METHOD ) KEEP (DENSE_RANK FIRST ORDER BY LEVEL)
8393: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
8394: WHERE ICC.ITEM_NUM_GEN_METHOD IS NOT NULL
8395: AND ICC.ITEM_NUM_GEN_METHOD <> 'I'
8396: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
8397: START WITH ICC.ITEM_CATALOG_GROUP_ID = MSII.ITEM_CATALOG_GROUP_ID

Line 12007: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG

12003: WHERE MP.ORGANIZATION_CODE = MSII.ORGANIZATION_CODE))
12004: ,ITEM_CATALOG_GROUP_ID =
12005: NVL(ITEM_CATALOG_GROUP_ID,
12006: (SELECT MICG.ITEM_CATALOG_GROUP_ID
12007: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG
12008: WHERE MICG.CONCATENATED_SEGMENTS = MSII.ITEM_CATALOG_GROUP_NAME))
12009: WHERE SET_PROCESS_ID = p_batch_id
12010: AND SOURCE_SYSTEM_ID = p_src_system_id
12011: AND SOURCE_SYSTEM_REFERENCE = p_src_system_ref