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_WS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 150: ego_attr_groups_v agv, mtl_system_items_b msib,

146: ent.PK2_VALUE AS "ORGANIZATION_ID",
147: ent.PK3_VALUE, FLAT.SEQUENCE_ID
148: FROM
149: ego_attrs_v attr, EGO_STYLE_VARIANT_ATTR_VS var,
150: ego_attr_groups_v agv, mtl_system_items_b msib,
151: EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat
152: WHERE
153: var.ATTRIBUTE_ID = attr.ATTR_ID
154: AND agv.ATTR_GROUP_NAME = attr.ATTR_GROUP_NAME

Line 288: ' FROM EGO_MTL_SY_ITEMS_EXT_B egob, EGO_ATTR_GROUPS_V AG, ego_attr_group_dl AGDL, mtl_system_items_b msib, '||

284: ' edlv.USER_DATA_LEVEL_NAME AS "DATA_LEVEL_NAME" , '||
285: ' flat.SEQUENCE_ID , '||
286: ' ent.PK3_VALUE AS "PK3_VALUE" , '||
287: ' flat.PK2_VALUE AS "ORG_ID" '||
288: ' FROM EGO_MTL_SY_ITEMS_EXT_B egob, EGO_ATTR_GROUPS_V AG, ego_attr_group_dl AGDL, mtl_system_items_b msib, '||
289: ' EGO_DATA_LEVEL_VL edlv , EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat '||
290: ' WHERE egob.DATA_LEVEL_ID = edlv.DATA_LEVEL_ID '||
291: ' AND egob.DATA_LEVEL_ID = AGDL.DATA_LEVEL_ID '||
292: ' AND AG.APPLICATION_ID = edlv.APPLICATION_ID '||

Line 1363: MTL_SYSTEM_ITEMS_B MSIB ,

1359: ).getclobval() ,
1360: SYSDATE
1361: FROM
1362: MTL_CROSS_REFERENCES EgoGtinEO ,
1363: MTL_SYSTEM_ITEMS_B MSIB ,
1364: MTL_PARAMETERS MP ,
1365: ( SELECT DISTINCT MCR1.CROSS_REFERENCE ,
1366: MSIK.INVENTORY_ITEM_ID ,
1367: MSIK.CONCATENATED_SEGMENTS ITEM_NUMBER ,

Line 1681: l_segment_1 mtl_system_items_b.segment1%TYPE;

1677: l_exists_rev_date NUMBER;
1678: l_inv_id NUMBER := -1;
1679: l_segments_provided BOOLEAN := FALSE;
1680:
1681: l_segment_1 mtl_system_items_b.segment1%TYPE;
1682: l_segment_2 mtl_system_items_b.segment2%TYPE;
1683: l_segment_3 mtl_system_items_b.segment3%TYPE;
1684: l_segment_4 mtl_system_items_b.segment4%TYPE;
1685: l_segment_5 mtl_system_items_b.segment5%TYPE;

Line 1682: l_segment_2 mtl_system_items_b.segment2%TYPE;

1678: l_inv_id NUMBER := -1;
1679: l_segments_provided BOOLEAN := FALSE;
1680:
1681: l_segment_1 mtl_system_items_b.segment1%TYPE;
1682: l_segment_2 mtl_system_items_b.segment2%TYPE;
1683: l_segment_3 mtl_system_items_b.segment3%TYPE;
1684: l_segment_4 mtl_system_items_b.segment4%TYPE;
1685: l_segment_5 mtl_system_items_b.segment5%TYPE;
1686: l_segment_6 mtl_system_items_b.segment6%TYPE;

Line 1683: l_segment_3 mtl_system_items_b.segment3%TYPE;

1679: l_segments_provided BOOLEAN := FALSE;
1680:
1681: l_segment_1 mtl_system_items_b.segment1%TYPE;
1682: l_segment_2 mtl_system_items_b.segment2%TYPE;
1683: l_segment_3 mtl_system_items_b.segment3%TYPE;
1684: l_segment_4 mtl_system_items_b.segment4%TYPE;
1685: l_segment_5 mtl_system_items_b.segment5%TYPE;
1686: l_segment_6 mtl_system_items_b.segment6%TYPE;
1687: l_segment_7 mtl_system_items_b.segment7%TYPE;

Line 1684: l_segment_4 mtl_system_items_b.segment4%TYPE;

1680:
1681: l_segment_1 mtl_system_items_b.segment1%TYPE;
1682: l_segment_2 mtl_system_items_b.segment2%TYPE;
1683: l_segment_3 mtl_system_items_b.segment3%TYPE;
1684: l_segment_4 mtl_system_items_b.segment4%TYPE;
1685: l_segment_5 mtl_system_items_b.segment5%TYPE;
1686: l_segment_6 mtl_system_items_b.segment6%TYPE;
1687: l_segment_7 mtl_system_items_b.segment7%TYPE;
1688: l_segment_8 mtl_system_items_b.segment8%TYPE;

Line 1685: l_segment_5 mtl_system_items_b.segment5%TYPE;

1681: l_segment_1 mtl_system_items_b.segment1%TYPE;
1682: l_segment_2 mtl_system_items_b.segment2%TYPE;
1683: l_segment_3 mtl_system_items_b.segment3%TYPE;
1684: l_segment_4 mtl_system_items_b.segment4%TYPE;
1685: l_segment_5 mtl_system_items_b.segment5%TYPE;
1686: l_segment_6 mtl_system_items_b.segment6%TYPE;
1687: l_segment_7 mtl_system_items_b.segment7%TYPE;
1688: l_segment_8 mtl_system_items_b.segment8%TYPE;
1689: l_segment_9 mtl_system_items_b.segment9%TYPE;

Line 1686: l_segment_6 mtl_system_items_b.segment6%TYPE;

1682: l_segment_2 mtl_system_items_b.segment2%TYPE;
1683: l_segment_3 mtl_system_items_b.segment3%TYPE;
1684: l_segment_4 mtl_system_items_b.segment4%TYPE;
1685: l_segment_5 mtl_system_items_b.segment5%TYPE;
1686: l_segment_6 mtl_system_items_b.segment6%TYPE;
1687: l_segment_7 mtl_system_items_b.segment7%TYPE;
1688: l_segment_8 mtl_system_items_b.segment8%TYPE;
1689: l_segment_9 mtl_system_items_b.segment9%TYPE;
1690: l_segment_10 mtl_system_items_b.segment10%TYPE;

Line 1687: l_segment_7 mtl_system_items_b.segment7%TYPE;

1683: l_segment_3 mtl_system_items_b.segment3%TYPE;
1684: l_segment_4 mtl_system_items_b.segment4%TYPE;
1685: l_segment_5 mtl_system_items_b.segment5%TYPE;
1686: l_segment_6 mtl_system_items_b.segment6%TYPE;
1687: l_segment_7 mtl_system_items_b.segment7%TYPE;
1688: l_segment_8 mtl_system_items_b.segment8%TYPE;
1689: l_segment_9 mtl_system_items_b.segment9%TYPE;
1690: l_segment_10 mtl_system_items_b.segment10%TYPE;
1691: l_segment_11 mtl_system_items_b.segment11%TYPE;

Line 1688: l_segment_8 mtl_system_items_b.segment8%TYPE;

1684: l_segment_4 mtl_system_items_b.segment4%TYPE;
1685: l_segment_5 mtl_system_items_b.segment5%TYPE;
1686: l_segment_6 mtl_system_items_b.segment6%TYPE;
1687: l_segment_7 mtl_system_items_b.segment7%TYPE;
1688: l_segment_8 mtl_system_items_b.segment8%TYPE;
1689: l_segment_9 mtl_system_items_b.segment9%TYPE;
1690: l_segment_10 mtl_system_items_b.segment10%TYPE;
1691: l_segment_11 mtl_system_items_b.segment11%TYPE;
1692: l_segment_12 mtl_system_items_b.segment12%TYPE;

Line 1689: l_segment_9 mtl_system_items_b.segment9%TYPE;

1685: l_segment_5 mtl_system_items_b.segment5%TYPE;
1686: l_segment_6 mtl_system_items_b.segment6%TYPE;
1687: l_segment_7 mtl_system_items_b.segment7%TYPE;
1688: l_segment_8 mtl_system_items_b.segment8%TYPE;
1689: l_segment_9 mtl_system_items_b.segment9%TYPE;
1690: l_segment_10 mtl_system_items_b.segment10%TYPE;
1691: l_segment_11 mtl_system_items_b.segment11%TYPE;
1692: l_segment_12 mtl_system_items_b.segment12%TYPE;
1693: l_segment_13 mtl_system_items_b.segment13%TYPE;

Line 1690: l_segment_10 mtl_system_items_b.segment10%TYPE;

1686: l_segment_6 mtl_system_items_b.segment6%TYPE;
1687: l_segment_7 mtl_system_items_b.segment7%TYPE;
1688: l_segment_8 mtl_system_items_b.segment8%TYPE;
1689: l_segment_9 mtl_system_items_b.segment9%TYPE;
1690: l_segment_10 mtl_system_items_b.segment10%TYPE;
1691: l_segment_11 mtl_system_items_b.segment11%TYPE;
1692: l_segment_12 mtl_system_items_b.segment12%TYPE;
1693: l_segment_13 mtl_system_items_b.segment13%TYPE;
1694: l_segment_14 mtl_system_items_b.segment14%TYPE;

Line 1691: l_segment_11 mtl_system_items_b.segment11%TYPE;

1687: l_segment_7 mtl_system_items_b.segment7%TYPE;
1688: l_segment_8 mtl_system_items_b.segment8%TYPE;
1689: l_segment_9 mtl_system_items_b.segment9%TYPE;
1690: l_segment_10 mtl_system_items_b.segment10%TYPE;
1691: l_segment_11 mtl_system_items_b.segment11%TYPE;
1692: l_segment_12 mtl_system_items_b.segment12%TYPE;
1693: l_segment_13 mtl_system_items_b.segment13%TYPE;
1694: l_segment_14 mtl_system_items_b.segment14%TYPE;
1695: l_segment_15 mtl_system_items_b.segment15%TYPE;

Line 1692: l_segment_12 mtl_system_items_b.segment12%TYPE;

1688: l_segment_8 mtl_system_items_b.segment8%TYPE;
1689: l_segment_9 mtl_system_items_b.segment9%TYPE;
1690: l_segment_10 mtl_system_items_b.segment10%TYPE;
1691: l_segment_11 mtl_system_items_b.segment11%TYPE;
1692: l_segment_12 mtl_system_items_b.segment12%TYPE;
1693: l_segment_13 mtl_system_items_b.segment13%TYPE;
1694: l_segment_14 mtl_system_items_b.segment14%TYPE;
1695: l_segment_15 mtl_system_items_b.segment15%TYPE;
1696:

Line 1693: l_segment_13 mtl_system_items_b.segment13%TYPE;

1689: l_segment_9 mtl_system_items_b.segment9%TYPE;
1690: l_segment_10 mtl_system_items_b.segment10%TYPE;
1691: l_segment_11 mtl_system_items_b.segment11%TYPE;
1692: l_segment_12 mtl_system_items_b.segment12%TYPE;
1693: l_segment_13 mtl_system_items_b.segment13%TYPE;
1694: l_segment_14 mtl_system_items_b.segment14%TYPE;
1695: l_segment_15 mtl_system_items_b.segment15%TYPE;
1696:
1697: BEGIN

Line 1694: l_segment_14 mtl_system_items_b.segment14%TYPE;

1690: l_segment_10 mtl_system_items_b.segment10%TYPE;
1691: l_segment_11 mtl_system_items_b.segment11%TYPE;
1692: l_segment_12 mtl_system_items_b.segment12%TYPE;
1693: l_segment_13 mtl_system_items_b.segment13%TYPE;
1694: l_segment_14 mtl_system_items_b.segment14%TYPE;
1695: l_segment_15 mtl_system_items_b.segment15%TYPE;
1696:
1697: BEGIN
1698:

Line 1695: l_segment_15 mtl_system_items_b.segment15%TYPE;

1691: l_segment_11 mtl_system_items_b.segment11%TYPE;
1692: l_segment_12 mtl_system_items_b.segment12%TYPE;
1693: l_segment_13 mtl_system_items_b.segment13%TYPE;
1694: l_segment_14 mtl_system_items_b.segment14%TYPE;
1695: l_segment_15 mtl_system_items_b.segment15%TYPE;
1696:
1697: BEGIN
1698:
1699: --if BatchId node exist and It has some value then we are in 'BATCH' mode

Line 1883: FROM bom_explosions_all be , mtl_system_items_b_kfv ego

1879: ,ego.organization_id AS org_id
1880: ,bom_exploder_pub.get_component_revision_id(nvl(be.component_sequence_id, 0)) AS rev_id
1881: , bom_exploder_pub.get_component_revision_label(nvl(be.component_sequence_id, 0)) AS rev_label
1882: , be.plan_level AS plan_level
1883: FROM bom_explosions_all be , mtl_system_items_b_kfv ego
1884: WHERE be.group_id = grp_id
1885: AND ego.inventory_item_id = be.component_item_id
1886: AND ego.organization_id = be.organization_id
1887: AND be.plan_level <= levels

Line 3466: l_segment_1 mtl_system_items_b.segment1%TYPE;

3462: l_revision VARCHAR2(10) := NULL;
3463: l_rev_date DATE := NULL;
3464: l_exists_items_list NUMBER;
3465:
3466: l_segment_1 mtl_system_items_b.segment1%TYPE;
3467: l_segment_2 mtl_system_items_b.segment2%TYPE;
3468: l_segment_3 mtl_system_items_b.segment3%TYPE;
3469: l_segment_4 mtl_system_items_b.segment4%TYPE;
3470: l_segment_5 mtl_system_items_b.segment5%TYPE;

Line 3467: l_segment_2 mtl_system_items_b.segment2%TYPE;

3463: l_rev_date DATE := NULL;
3464: l_exists_items_list NUMBER;
3465:
3466: l_segment_1 mtl_system_items_b.segment1%TYPE;
3467: l_segment_2 mtl_system_items_b.segment2%TYPE;
3468: l_segment_3 mtl_system_items_b.segment3%TYPE;
3469: l_segment_4 mtl_system_items_b.segment4%TYPE;
3470: l_segment_5 mtl_system_items_b.segment5%TYPE;
3471: l_segment_6 mtl_system_items_b.segment6%TYPE;

Line 3468: l_segment_3 mtl_system_items_b.segment3%TYPE;

3464: l_exists_items_list NUMBER;
3465:
3466: l_segment_1 mtl_system_items_b.segment1%TYPE;
3467: l_segment_2 mtl_system_items_b.segment2%TYPE;
3468: l_segment_3 mtl_system_items_b.segment3%TYPE;
3469: l_segment_4 mtl_system_items_b.segment4%TYPE;
3470: l_segment_5 mtl_system_items_b.segment5%TYPE;
3471: l_segment_6 mtl_system_items_b.segment6%TYPE;
3472: l_segment_7 mtl_system_items_b.segment7%TYPE;

Line 3469: l_segment_4 mtl_system_items_b.segment4%TYPE;

3465:
3466: l_segment_1 mtl_system_items_b.segment1%TYPE;
3467: l_segment_2 mtl_system_items_b.segment2%TYPE;
3468: l_segment_3 mtl_system_items_b.segment3%TYPE;
3469: l_segment_4 mtl_system_items_b.segment4%TYPE;
3470: l_segment_5 mtl_system_items_b.segment5%TYPE;
3471: l_segment_6 mtl_system_items_b.segment6%TYPE;
3472: l_segment_7 mtl_system_items_b.segment7%TYPE;
3473: l_segment_8 mtl_system_items_b.segment8%TYPE;

Line 3470: l_segment_5 mtl_system_items_b.segment5%TYPE;

3466: l_segment_1 mtl_system_items_b.segment1%TYPE;
3467: l_segment_2 mtl_system_items_b.segment2%TYPE;
3468: l_segment_3 mtl_system_items_b.segment3%TYPE;
3469: l_segment_4 mtl_system_items_b.segment4%TYPE;
3470: l_segment_5 mtl_system_items_b.segment5%TYPE;
3471: l_segment_6 mtl_system_items_b.segment6%TYPE;
3472: l_segment_7 mtl_system_items_b.segment7%TYPE;
3473: l_segment_8 mtl_system_items_b.segment8%TYPE;
3474: l_segment_9 mtl_system_items_b.segment9%TYPE;

Line 3471: l_segment_6 mtl_system_items_b.segment6%TYPE;

3467: l_segment_2 mtl_system_items_b.segment2%TYPE;
3468: l_segment_3 mtl_system_items_b.segment3%TYPE;
3469: l_segment_4 mtl_system_items_b.segment4%TYPE;
3470: l_segment_5 mtl_system_items_b.segment5%TYPE;
3471: l_segment_6 mtl_system_items_b.segment6%TYPE;
3472: l_segment_7 mtl_system_items_b.segment7%TYPE;
3473: l_segment_8 mtl_system_items_b.segment8%TYPE;
3474: l_segment_9 mtl_system_items_b.segment9%TYPE;
3475: l_segment_10 mtl_system_items_b.segment10%TYPE;

Line 3472: l_segment_7 mtl_system_items_b.segment7%TYPE;

3468: l_segment_3 mtl_system_items_b.segment3%TYPE;
3469: l_segment_4 mtl_system_items_b.segment4%TYPE;
3470: l_segment_5 mtl_system_items_b.segment5%TYPE;
3471: l_segment_6 mtl_system_items_b.segment6%TYPE;
3472: l_segment_7 mtl_system_items_b.segment7%TYPE;
3473: l_segment_8 mtl_system_items_b.segment8%TYPE;
3474: l_segment_9 mtl_system_items_b.segment9%TYPE;
3475: l_segment_10 mtl_system_items_b.segment10%TYPE;
3476: l_segment_11 mtl_system_items_b.segment11%TYPE;

Line 3473: l_segment_8 mtl_system_items_b.segment8%TYPE;

3469: l_segment_4 mtl_system_items_b.segment4%TYPE;
3470: l_segment_5 mtl_system_items_b.segment5%TYPE;
3471: l_segment_6 mtl_system_items_b.segment6%TYPE;
3472: l_segment_7 mtl_system_items_b.segment7%TYPE;
3473: l_segment_8 mtl_system_items_b.segment8%TYPE;
3474: l_segment_9 mtl_system_items_b.segment9%TYPE;
3475: l_segment_10 mtl_system_items_b.segment10%TYPE;
3476: l_segment_11 mtl_system_items_b.segment11%TYPE;
3477: l_segment_12 mtl_system_items_b.segment12%TYPE;

Line 3474: l_segment_9 mtl_system_items_b.segment9%TYPE;

3470: l_segment_5 mtl_system_items_b.segment5%TYPE;
3471: l_segment_6 mtl_system_items_b.segment6%TYPE;
3472: l_segment_7 mtl_system_items_b.segment7%TYPE;
3473: l_segment_8 mtl_system_items_b.segment8%TYPE;
3474: l_segment_9 mtl_system_items_b.segment9%TYPE;
3475: l_segment_10 mtl_system_items_b.segment10%TYPE;
3476: l_segment_11 mtl_system_items_b.segment11%TYPE;
3477: l_segment_12 mtl_system_items_b.segment12%TYPE;
3478: l_segment_13 mtl_system_items_b.segment13%TYPE;

Line 3475: l_segment_10 mtl_system_items_b.segment10%TYPE;

3471: l_segment_6 mtl_system_items_b.segment6%TYPE;
3472: l_segment_7 mtl_system_items_b.segment7%TYPE;
3473: l_segment_8 mtl_system_items_b.segment8%TYPE;
3474: l_segment_9 mtl_system_items_b.segment9%TYPE;
3475: l_segment_10 mtl_system_items_b.segment10%TYPE;
3476: l_segment_11 mtl_system_items_b.segment11%TYPE;
3477: l_segment_12 mtl_system_items_b.segment12%TYPE;
3478: l_segment_13 mtl_system_items_b.segment13%TYPE;
3479: l_segment_14 mtl_system_items_b.segment14%TYPE;

Line 3476: l_segment_11 mtl_system_items_b.segment11%TYPE;

3472: l_segment_7 mtl_system_items_b.segment7%TYPE;
3473: l_segment_8 mtl_system_items_b.segment8%TYPE;
3474: l_segment_9 mtl_system_items_b.segment9%TYPE;
3475: l_segment_10 mtl_system_items_b.segment10%TYPE;
3476: l_segment_11 mtl_system_items_b.segment11%TYPE;
3477: l_segment_12 mtl_system_items_b.segment12%TYPE;
3478: l_segment_13 mtl_system_items_b.segment13%TYPE;
3479: l_segment_14 mtl_system_items_b.segment14%TYPE;
3480: l_segment_15 mtl_system_items_b.segment15%TYPE;

Line 3477: l_segment_12 mtl_system_items_b.segment12%TYPE;

3473: l_segment_8 mtl_system_items_b.segment8%TYPE;
3474: l_segment_9 mtl_system_items_b.segment9%TYPE;
3475: l_segment_10 mtl_system_items_b.segment10%TYPE;
3476: l_segment_11 mtl_system_items_b.segment11%TYPE;
3477: l_segment_12 mtl_system_items_b.segment12%TYPE;
3478: l_segment_13 mtl_system_items_b.segment13%TYPE;
3479: l_segment_14 mtl_system_items_b.segment14%TYPE;
3480: l_segment_15 mtl_system_items_b.segment15%TYPE;
3481: l_segment_16 mtl_system_items_b.segment16%TYPE;

Line 3478: l_segment_13 mtl_system_items_b.segment13%TYPE;

3474: l_segment_9 mtl_system_items_b.segment9%TYPE;
3475: l_segment_10 mtl_system_items_b.segment10%TYPE;
3476: l_segment_11 mtl_system_items_b.segment11%TYPE;
3477: l_segment_12 mtl_system_items_b.segment12%TYPE;
3478: l_segment_13 mtl_system_items_b.segment13%TYPE;
3479: l_segment_14 mtl_system_items_b.segment14%TYPE;
3480: l_segment_15 mtl_system_items_b.segment15%TYPE;
3481: l_segment_16 mtl_system_items_b.segment16%TYPE;
3482: l_segment_17 mtl_system_items_b.segment17%TYPE;

Line 3479: l_segment_14 mtl_system_items_b.segment14%TYPE;

3475: l_segment_10 mtl_system_items_b.segment10%TYPE;
3476: l_segment_11 mtl_system_items_b.segment11%TYPE;
3477: l_segment_12 mtl_system_items_b.segment12%TYPE;
3478: l_segment_13 mtl_system_items_b.segment13%TYPE;
3479: l_segment_14 mtl_system_items_b.segment14%TYPE;
3480: l_segment_15 mtl_system_items_b.segment15%TYPE;
3481: l_segment_16 mtl_system_items_b.segment16%TYPE;
3482: l_segment_17 mtl_system_items_b.segment17%TYPE;
3483: l_segment_18 mtl_system_items_b.segment18%TYPE;

Line 3480: l_segment_15 mtl_system_items_b.segment15%TYPE;

3476: l_segment_11 mtl_system_items_b.segment11%TYPE;
3477: l_segment_12 mtl_system_items_b.segment12%TYPE;
3478: l_segment_13 mtl_system_items_b.segment13%TYPE;
3479: l_segment_14 mtl_system_items_b.segment14%TYPE;
3480: l_segment_15 mtl_system_items_b.segment15%TYPE;
3481: l_segment_16 mtl_system_items_b.segment16%TYPE;
3482: l_segment_17 mtl_system_items_b.segment17%TYPE;
3483: l_segment_18 mtl_system_items_b.segment18%TYPE;
3484: l_segment_19 mtl_system_items_b.segment19%TYPE;

Line 3481: l_segment_16 mtl_system_items_b.segment16%TYPE;

3477: l_segment_12 mtl_system_items_b.segment12%TYPE;
3478: l_segment_13 mtl_system_items_b.segment13%TYPE;
3479: l_segment_14 mtl_system_items_b.segment14%TYPE;
3480: l_segment_15 mtl_system_items_b.segment15%TYPE;
3481: l_segment_16 mtl_system_items_b.segment16%TYPE;
3482: l_segment_17 mtl_system_items_b.segment17%TYPE;
3483: l_segment_18 mtl_system_items_b.segment18%TYPE;
3484: l_segment_19 mtl_system_items_b.segment19%TYPE;
3485: l_segment_20 mtl_system_items_b.segment20%TYPE;

Line 3482: l_segment_17 mtl_system_items_b.segment17%TYPE;

3478: l_segment_13 mtl_system_items_b.segment13%TYPE;
3479: l_segment_14 mtl_system_items_b.segment14%TYPE;
3480: l_segment_15 mtl_system_items_b.segment15%TYPE;
3481: l_segment_16 mtl_system_items_b.segment16%TYPE;
3482: l_segment_17 mtl_system_items_b.segment17%TYPE;
3483: l_segment_18 mtl_system_items_b.segment18%TYPE;
3484: l_segment_19 mtl_system_items_b.segment19%TYPE;
3485: l_segment_20 mtl_system_items_b.segment20%TYPE;
3486:

Line 3483: l_segment_18 mtl_system_items_b.segment18%TYPE;

3479: l_segment_14 mtl_system_items_b.segment14%TYPE;
3480: l_segment_15 mtl_system_items_b.segment15%TYPE;
3481: l_segment_16 mtl_system_items_b.segment16%TYPE;
3482: l_segment_17 mtl_system_items_b.segment17%TYPE;
3483: l_segment_18 mtl_system_items_b.segment18%TYPE;
3484: l_segment_19 mtl_system_items_b.segment19%TYPE;
3485: l_segment_20 mtl_system_items_b.segment20%TYPE;
3486:
3487: l_item_id_tab dbms_sql.VARCHAR2_table;

Line 3484: l_segment_19 mtl_system_items_b.segment19%TYPE;

3480: l_segment_15 mtl_system_items_b.segment15%TYPE;
3481: l_segment_16 mtl_system_items_b.segment16%TYPE;
3482: l_segment_17 mtl_system_items_b.segment17%TYPE;
3483: l_segment_18 mtl_system_items_b.segment18%TYPE;
3484: l_segment_19 mtl_system_items_b.segment19%TYPE;
3485: l_segment_20 mtl_system_items_b.segment20%TYPE;
3486:
3487: l_item_id_tab dbms_sql.VARCHAR2_table;
3488: l_org_id_tab dbms_sql.VARCHAR2_table;

Line 3485: l_segment_20 mtl_system_items_b.segment20%TYPE;

3481: l_segment_16 mtl_system_items_b.segment16%TYPE;
3482: l_segment_17 mtl_system_items_b.segment17%TYPE;
3483: l_segment_18 mtl_system_items_b.segment18%TYPE;
3484: l_segment_19 mtl_system_items_b.segment19%TYPE;
3485: l_segment_20 mtl_system_items_b.segment20%TYPE;
3486:
3487: l_item_id_tab dbms_sql.VARCHAR2_table;
3488: l_org_id_tab dbms_sql.VARCHAR2_table;
3489: l_org_code_tab dbms_sql.VARCHAR2_table;

Line 4705: l_component_name mtl_system_items_b_kfv.CONCATENATED_SEGMENTS%TYPE;

4701: l_user_name VARCHAR2(100);
4702: l_structure_name VARCHAR2(100);
4703: p_index number;
4704: l_seq_number NUMBER;
4705: l_component_name mtl_system_items_b_kfv.CONCATENATED_SEGMENTS%TYPE;
4706:
4707: TYPE DYNAMIC_CUR IS REF CURSOR;
4708: v_dynamic_cursor DYNAMIC_CUR;
4709:

Line 4844: from mtl_system_items_b_kfv

4840: EXIT WHEN v_dynamic_cursor%NOTFOUND;
4841:
4842: select CONCATENATED_SEGMENTS
4843: into l_component_name
4844: from mtl_system_items_b_kfv
4845: WHERE inventory_item_id = l_item_id
4846: AND ORGANIZATION_ID = l_org_id;
4847:
4848: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

Line 4895: from mtl_system_items_b_kfv

4891: AND SEQUENCE_NUMBER IS NULL)
4892: loop
4893: select CONCATENATED_SEGMENTS
4894: into l_component_name
4895: from mtl_system_items_b_kfv
4896: WHERE inventory_item_id = i.PK1_VALUE
4897: AND ORGANIZATION_ID = i.PK2_VALUE;
4898:
4899: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,