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.CTO_UPDATE_ITEMS_PK dependencies on MTL_CROSS_REFERENCES

Line 56: | In R12, mtl_cross_references datamodel has been changed to

52: |
53: |
54: | Modified on 08-Aug-2005 by Kiran Konada
55: | bug# 4539578
56: | In R12, mtl_cross_references datamodel has been changed to
57: | mtl_cross_references_b and mtl_cross_references_tl
58: |
59: |
60: | Modified on 22-Sep-2005 Renga Kannan

Line 57: | mtl_cross_references_b and mtl_cross_references_tl

53: |
54: | Modified on 08-Aug-2005 by Kiran Konada
55: | bug# 4539578
56: | In R12, mtl_cross_references datamodel has been changed to
57: | mtl_cross_references_b and mtl_cross_references_tl
58: |
59: |
60: | Modified on 22-Sep-2005 Renga Kannan
61: | Made Code changes for ATG Performance

Line 1135: --for mtl_cross_references_b

1131:
1132: v_cto_cost_type_name cst_cost_types.cost_type%type;
1133:
1134: --kkonada R12
1135: --for mtl_cross_references_b
1136: --bug# 4539578
1137:
1138: TYPE cfg_item_id IS TABLE OF bom_cto_order_lines_upg.config_item_id%type;
1139: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;

Line 1139: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;

1135: --for mtl_cross_references_b
1136: --bug# 4539578
1137:
1138: TYPE cfg_item_id IS TABLE OF bom_cto_order_lines_upg.config_item_id%type;
1139: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
1140: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;
1141: TYPE cross_reference IS TABLE OF mtl_cross_references_b.cross_reference%type;
1142: TYPE org_independent_flag IS TABLE OF mtl_cross_references_b.org_independent_flag%type;
1143:

Line 1140: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;

1136: --bug# 4539578
1137:
1138: TYPE cfg_item_id IS TABLE OF bom_cto_order_lines_upg.config_item_id%type;
1139: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
1140: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;
1141: TYPE cross_reference IS TABLE OF mtl_cross_references_b.cross_reference%type;
1142: TYPE org_independent_flag IS TABLE OF mtl_cross_references_b.org_independent_flag%type;
1143:
1144: t_cfg_item_id cfg_item_id;

Line 1141: TYPE cross_reference IS TABLE OF mtl_cross_references_b.cross_reference%type;

1137:
1138: TYPE cfg_item_id IS TABLE OF bom_cto_order_lines_upg.config_item_id%type;
1139: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
1140: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;
1141: TYPE cross_reference IS TABLE OF mtl_cross_references_b.cross_reference%type;
1142: TYPE org_independent_flag IS TABLE OF mtl_cross_references_b.org_independent_flag%type;
1143:
1144: t_cfg_item_id cfg_item_id;
1145: t_organization_id org_id;

Line 1142: TYPE org_independent_flag IS TABLE OF mtl_cross_references_b.org_independent_flag%type;

1138: TYPE cfg_item_id IS TABLE OF bom_cto_order_lines_upg.config_item_id%type;
1139: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
1140: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;
1141: TYPE cross_reference IS TABLE OF mtl_cross_references_b.cross_reference%type;
1142: TYPE org_independent_flag IS TABLE OF mtl_cross_references_b.org_independent_flag%type;
1143:
1144: t_cfg_item_id cfg_item_id;
1145: t_organization_id org_id;
1146: t_cross_ref_type cross_reference_type;

Line 2730: mtl_cross_references_b cr_b,

2726: t_cross_ref_type,
2727: t_cross_ref,
2728: t_org_independent_flag
2729: from
2730: mtl_cross_references_b cr_b,
2731: bom_cto_src_orgs bcso,
2732: bom_cto_order_lines_upg bcolu
2733: where bcolu.config_item_id is not null
2734: and bcolu.status = 'BCSO'

Line 2742: from mtl_cross_references

2738: and bcso.model_item_id = bcolu.inventory_item_id
2739: and bcso.line_id = bcolu.line_id
2740: and NOT EXISTS
2741: (select NULL
2742: from mtl_cross_references
2743: where inventory_item_id = bcolu.config_item_id
2744: and (organization_id = bcso.organization_id
2745: or organization_id is null)); -- bugfix 1960994: added OR condition
2746:

Line 2751: INSERT INTO MTL_CROSS_REFERENCES_B

2747:
2748: IF t_cross_ref_type.count <> 0 THEN
2749:
2750: FORALL i IN 1..t_cross_ref_type.count
2751: INSERT INTO MTL_CROSS_REFERENCES_B
2752: (
2753: INVENTORY_ITEM_ID
2754: ,ORGANIZATION_ID
2755: ,CROSS_REFERENCE_TYPE

Line 2808: ,NULL --UOM_CODE due to ER#3215422. do not copy uom_code and revision_id attribute for mtl_cross_references

2804: ,NULL --PROGRAM_ID
2805: ,SYSDATE --PROGRAM_UPDATE_DATE
2806: ,NULL --SOURCE_SYSTEM_ID
2807: ,1 --OBJECT_VERSION_NUMBER
2808: ,NULL --UOM_CODE due to ER#3215422. do not copy uom_code and revision_id attribute for mtl_cross_references
2809: ,NULL --REVISION_ID due to ER#3215422. do not copy uom_code and revision_id attribute for mtl_cross_references
2810: ,MTL_CROSS_REFERENCES_B_S.NEXTVAL --CROSS_REFERENCE_ID
2811: ,0 --EPC_GTIN_SERIAL
2812: ,NULL --ATTRIBUTE1

Line 2809: ,NULL --REVISION_ID due to ER#3215422. do not copy uom_code and revision_id attribute for mtl_cross_references

2805: ,SYSDATE --PROGRAM_UPDATE_DATE
2806: ,NULL --SOURCE_SYSTEM_ID
2807: ,1 --OBJECT_VERSION_NUMBER
2808: ,NULL --UOM_CODE due to ER#3215422. do not copy uom_code and revision_id attribute for mtl_cross_references
2809: ,NULL --REVISION_ID due to ER#3215422. do not copy uom_code and revision_id attribute for mtl_cross_references
2810: ,MTL_CROSS_REFERENCES_B_S.NEXTVAL --CROSS_REFERENCE_ID
2811: ,0 --EPC_GTIN_SERIAL
2812: ,NULL --ATTRIBUTE1
2813: ,NULL --ATTRIBUTE2

Line 2810: ,MTL_CROSS_REFERENCES_B_S.NEXTVAL --CROSS_REFERENCE_ID

2806: ,NULL --SOURCE_SYSTEM_ID
2807: ,1 --OBJECT_VERSION_NUMBER
2808: ,NULL --UOM_CODE due to ER#3215422. do not copy uom_code and revision_id attribute for mtl_cross_references
2809: ,NULL --REVISION_ID due to ER#3215422. do not copy uom_code and revision_id attribute for mtl_cross_references
2810: ,MTL_CROSS_REFERENCES_B_S.NEXTVAL --CROSS_REFERENCE_ID
2811: ,0 --EPC_GTIN_SERIAL
2812: ,NULL --ATTRIBUTE1
2813: ,NULL --ATTRIBUTE2
2814: ,NULL --ATTRIBUTE3

Line 2830: WriteToLog('Inserted rows into mtl_cross_references_b:: '||sql%rowcount,2);

2826: ,NULL --ATTRIBUTE15
2827: ,NULL --ATTRIBUTE_CATEGORY
2828: );
2829:
2830: WriteToLog('Inserted rows into mtl_cross_references_b:: '||sql%rowcount,2);
2831:
2832: FORALL i IN 1..t_cfg_item_id.count
2833: INSERT INTO mtl_cross_references_tl (
2834: last_update_login

Line 2833: INSERT INTO mtl_cross_references_tl (

2829:
2830: WriteToLog('Inserted rows into mtl_cross_references_b:: '||sql%rowcount,2);
2831:
2832: FORALL i IN 1..t_cfg_item_id.count
2833: INSERT INTO mtl_cross_references_tl (
2834: last_update_login
2835: ,description
2836: ,creation_date
2837: ,created_by

Line 2854: mtl_cross_references_b mtl_cross,

2850: mtl_cross.cross_reference_id,
2851: l.language_code,
2852: userenv('lang')
2853: FROM fnd_languages l,
2854: mtl_cross_references_b mtl_cross,
2855: mtl_system_items_tl mtl
2856: WHERE mtl_cross.inventory_item_id = t_cfg_item_id(i)
2857: AND mtl_cross.inventory_item_id = mtl.inventory_item_id
2858: AND mtl_cross.organization_id = mtl.organization_id

Line 2862: FROM mtl_cross_references_tl t

2858: AND mtl_cross.organization_id = mtl.organization_id
2859: AND l.language_code = mtl.language
2860: AND l.installed_flag in ('I', 'B')
2861: AND NOT EXISTS (SELECT null
2862: FROM mtl_cross_references_tl t
2863: WHERE t.cross_reference_id = mtl_cross.cross_reference_id
2864: AND t.language = l.language_code);
2865:
2866: WriteToLog('Inserted rows into mtl_cross_references_tl:: '||sql%rowcount,2);

Line 2866: WriteToLog('Inserted rows into mtl_cross_references_tl:: '||sql%rowcount,2);

2862: FROM mtl_cross_references_tl t
2863: WHERE t.cross_reference_id = mtl_cross.cross_reference_id
2864: AND t.language = l.language_code);
2865:
2866: WriteToLog('Inserted rows into mtl_cross_references_tl:: '||sql%rowcount,2);
2867:
2868:
2869: END IF; --t_cross_ref_type.count()
2870: