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 6115: l_item_num_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;

6111: l_pdh_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
6112: l_pdh_description MTL_SYSTEM_ITEMS_INTERFACE.DESCRIPTION%TYPE;
6113: l_pdh_item_catalog_group_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
6114: l_confirm_status MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE;
6115: l_item_num_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6116: l_item_desc_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6117: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6118: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6119: l_batch_rev_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;

Line 6116: l_item_desc_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;

6112: l_pdh_description MTL_SYSTEM_ITEMS_INTERFACE.DESCRIPTION%TYPE;
6113: l_pdh_item_catalog_group_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
6114: l_confirm_status MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE;
6115: l_item_num_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6116: l_item_desc_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6117: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6118: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6119: l_batch_rev_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
6120: l_instance_rev_policy MTL_SYSTEM_ITEMS_INTERFACE.REVISION_IMPORT_POLICY%TYPE;

Line 6148: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG

6144: ATTR.ENABLED_FLAG = 'Y' AND
6145: ATTR.ATTRIBUTE_NAME LIKE 'MTL_SYSTEM_ITEMS.DESCRIPTION')),
6146: NVL(ITEM_CATALOG_GROUP_ID,
6147: ( SELECT MICG.ITEM_CATALOG_GROUP_ID
6148: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG
6149: WHERE MICG.CONCATENATED_SEGMENTS = MSII.ITEM_CATALOG_GROUP_NAME)),
6150: CONFIRM_STATUS,
6151: NVL(REVISION_IMPORT_POLICY, l_batch_rev_policy),
6152: MSII.STYLE_ITEM_FLAG

Line 6228: l_item_num_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;

6224: x_item_num_gen_method OUT NOCOPY VARCHAR2,
6225: x_item_desc_gen_method OUT NOCOPY VARCHAR2) IS
6226: l_num_gen_resolved VARCHAR2(1) := 'N';
6227: l_desc_gen_resolved VARCHAR2(1) := 'N';
6228: l_item_num_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6229: l_item_desc_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6230:
6231: CURSOR c_gen_method IS
6232: SELECT

Line 6229: l_item_desc_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;

6225: x_item_desc_gen_method OUT NOCOPY VARCHAR2) IS
6226: l_num_gen_resolved VARCHAR2(1) := 'N';
6227: l_desc_gen_resolved VARCHAR2(1) := 'N';
6228: l_item_num_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6229: l_item_desc_gen_method MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6230:
6231: CURSOR c_gen_method IS
6232: SELECT
6233: DECODE(ICC.ITEM_NUM_GEN_METHOD,

Line 6239: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

6235: ICC.ITEM_NUM_GEN_METHOD),
6236: DECODE(ICC.ITEM_DESC_GEN_METHOD,
6237: NULL, DECODE(ICC.PARENT_CATALOG_GROUP_ID, NULL, 'U', 'I'),
6238: ICC.ITEM_DESC_GEN_METHOD)
6239: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
6240: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
6241: START WITH ICC.ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id;
6242: BEGIN
6243: OPEN c_gen_method;

Line 7377: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG

7373: -- update the item_catalog_group_id
7374: UPDATE
7375: MTL_SYSTEM_ITEMS_INTERFACE MSII
7376: SET ITEM_CATALOG_GROUP_ID = (SELECT MICG.ITEM_CATALOG_GROUP_ID
7377: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG
7378: WHERE MICG.CONCATENATED_SEGMENTS = MSII.ITEM_CATALOG_GROUP_NAME)
7379: WHERE MSII.SET_PROCESS_ID = p_data_set_id
7380: AND MSII.PROCESS_FLAG = 0
7381: AND MSII.ORGANIZATION_ID = l_org_id

Line 8235: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

8231: AND ATTR.ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.DESCRIPTION'
8232: )
8233: AND 'F' <>
8234: (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
8235: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
8236: WHERE ICC.ITEM_DESC_GEN_METHOD IS NOT NULL
8237: AND ICC.ITEM_DESC_GEN_METHOD <> 'I'
8238: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
8239: START WITH ICC.ITEM_CATALOG_GROUP_ID = MSII.ITEM_CATALOG_GROUP_ID

Line 8250: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

8246: WHEN
8247: ( MSII.ITEM_CATALOG_GROUP_ID IS NOT NULL
8248: AND MSII.ITEM_NUMBER IS NULL
8249: 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
8250: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
8251: WHERE ICC.ITEM_NUM_GEN_METHOD IS NOT NULL
8252: AND ICC.ITEM_NUM_GEN_METHOD <> 'I'
8253: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
8254: START WITH ICC.ITEM_CATALOG_GROUP_ID = MSII.ITEM_CATALOG_GROUP_ID

Line 8290: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

8286: AND MSII.PROCESS_FLAG = 0
8287: AND MSII.CONFIRM_STATUS = 'CNR'
8288: AND MSII.ORGANIZATION_ID = l_org_id
8289: AND 'S' = ( SELECT MAX( ICC.ITEM_NUM_GEN_METHOD ) KEEP (DENSE_RANK FIRST ORDER BY LEVEL)
8290: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
8291: WHERE ICC.ITEM_NUM_GEN_METHOD IS NOT NULL
8292: AND ICC.ITEM_NUM_GEN_METHOD <> 'I'
8293: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID
8294: START WITH ICC.ITEM_CATALOG_GROUP_ID = MSII.ITEM_CATALOG_GROUP_ID

Line 11904: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG

11900: WHERE MP.ORGANIZATION_CODE = MSII.ORGANIZATION_CODE))
11901: ,ITEM_CATALOG_GROUP_ID =
11902: NVL(ITEM_CATALOG_GROUP_ID,
11903: (SELECT MICG.ITEM_CATALOG_GROUP_ID
11904: FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG
11905: WHERE MICG.CONCATENATED_SEGMENTS = MSII.ITEM_CATALOG_GROUP_NAME))
11906: WHERE SET_PROCESS_ID = p_batch_id
11907: AND SOURCE_SYSTEM_ID = p_src_system_id
11908: AND SOURCE_SYSTEM_REFERENCE = p_src_system_ref