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_CONFIG_ITEM_PK dependencies on MTL_CROSS_REFERENCES_B

Line 322: | mtl_cross_references_b and mtl_cross_references_tl

Line 6110: --for mtl_cross_references_b

6106:
6107: l_rt_cicd_summary cicd_summary_rec_tab ;
6108:
6109: --kkonada R12
6110: --for mtl_cross_references_b
6111: --bug# 4539578
6112:
6113: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
6114: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;

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

6109: --kkonada R12
6110: --for mtl_cross_references_b
6111: --bug# 4539578
6112:
6113: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
6114: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;
6115: TYPE cross_reference IS TABLE OF mtl_cross_references_b.cross_reference%type;
6116: TYPE org_independent_flag IS TABLE OF mtl_cross_references_b.org_independent_flag%type;
6117:

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

6110: --for mtl_cross_references_b
6111: --bug# 4539578
6112:
6113: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
6114: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;
6115: TYPE cross_reference IS TABLE OF mtl_cross_references_b.cross_reference%type;
6116: TYPE org_independent_flag IS TABLE OF mtl_cross_references_b.org_independent_flag%type;
6117:
6118:

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

6111: --bug# 4539578
6112:
6113: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
6114: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;
6115: TYPE cross_reference IS TABLE OF mtl_cross_references_b.cross_reference%type;
6116: TYPE org_independent_flag IS TABLE OF mtl_cross_references_b.org_independent_flag%type;
6117:
6118:
6119: t_organization_id org_id;

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

6112:
6113: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
6114: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;
6115: TYPE cross_reference IS TABLE OF mtl_cross_references_b.cross_reference%type;
6116: TYPE org_independent_flag IS TABLE OF mtl_cross_references_b.org_independent_flag%type;
6117:
6118:
6119: t_organization_id org_id;
6120: t_cross_ref_type cross_reference_type;

Line 7730: FROM MTL_CROSS_REFERENCES_B CR,

7726: t_organization_id,
7727: t_cross_ref_type,
7728: t_cross_ref,
7729: t_org_independent_flag
7730: FROM MTL_CROSS_REFERENCES_B CR,
7731: BOM_CTO_SRC_ORGS BCSO
7732: WHERE (CR.ORGANIZATION_ID = bcso.ORGANIZATION_ID OR CR.ORGANIZATION_ID IS NULL)
7733: AND CR.INVENTORY_ITEM_ID = PMODELID
7734: AND BCSO.MODEL_ITEM_ID = PMODELID

Line 7738: FROM MTL_CROSS_REFERENCES_B

7734: AND BCSO.MODEL_ITEM_ID = PMODELID
7735: AND BCSO.LINE_ID = PLINEID
7736: AND NOT EXISTS
7737: ( SELECT NULL
7738: FROM MTL_CROSS_REFERENCES_B
7739: WHERE INVENTORY_ITEM_ID = PCONFIGID
7740: AND ( ORGANIZATION_ID = bcso.ORGANIZATION_ID OR ORGANIZATION_ID IS NULL) -- bugfix 1960994: added OR condition
7741: );
7742:

Line 7746: INSERT INTO MTL_CROSS_REFERENCES_B

7742:
7743: IF t_cross_ref_type.count <> 0 THEN
7744:
7745: FORALL i IN 1..t_cross_ref_type.count
7746: INSERT INTO MTL_CROSS_REFERENCES_B
7747: (
7748: INVENTORY_ITEM_ID
7749: ,ORGANIZATION_ID
7750: ,CROSS_REFERENCE_TYPE

Line 7805: ,MTL_CROSS_REFERENCES_B_S.NEXTVAL --CROSS_REFERENCE_ID

7801: ,NULL --SOURCE_SYSTEM_ID
7802: ,1 --OBJECT_VERSION_NUMBER
7803: ,NULL --UOM_CODE due to ER#3215422. do not copy uom_code and revision_id attribute for mtl_cross_references
7804: ,NULL --REVISION_ID due to ER#3215422. do not copy uom_code and revision_id attribute for mtl_cross_references
7805: ,MTL_CROSS_REFERENCES_B_S.NEXTVAL --CROSS_REFERENCE_ID
7806: ,0 --EPC_GTIN_SERIAL
7807: ,NULL --ATTRIBUTE1
7808: ,NULL --ATTRIBUTE2
7809: ,NULL --ATTRIBUTE3

Line 7826: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_cross_references_b',2);

7822: ,NULL --ATTRIBUTE_CATEGORY
7823: );
7824:
7825: IF PG_DEBUG <> 0 THEN
7826: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_cross_references_b',2);
7827: oe_debug_pub.add('Create_Item: ' || '# of inserted rows mtl_cross_references_b'||sql%rowcount,2);
7828:
7829: END IF;
7830:

Line 7827: oe_debug_pub.add('Create_Item: ' || '# of inserted rows mtl_cross_references_b'||sql%rowcount,2);

7823: );
7824:
7825: IF PG_DEBUG <> 0 THEN
7826: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_cross_references_b',2);
7827: oe_debug_pub.add('Create_Item: ' || '# of inserted rows mtl_cross_references_b'||sql%rowcount,2);
7828:
7829: END IF;
7830:
7831: INSERT INTO mtl_cross_references_tl (

Line 7852: mtl_cross_references_b mtl_cross,

7848: mtl_cross.cross_reference_id,
7849: l.language_code,
7850: userenv('lang')
7851: FROM fnd_languages l,
7852: mtl_cross_references_b mtl_cross,
7853: mtl_system_items_tl mtl
7854: WHERE mtl_cross.inventory_item_id = pConfigId
7855: AND mtl_cross.inventory_item_id = mtl.inventory_item_id
7856: AND mtl_cross.organization_id = mtl.organization_id