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 6295: --for mtl_cross_references_b

6291:
6292: l_rt_cicd_summary cicd_summary_rec_tab ;
6293:
6294: --kkonada R12
6295: --for mtl_cross_references_b
6296: --bug# 4539578
6297:
6298: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
6299: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;

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

6294: --kkonada R12
6295: --for mtl_cross_references_b
6296: --bug# 4539578
6297:
6298: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
6299: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;
6300: TYPE cross_reference IS TABLE OF mtl_cross_references_b.cross_reference%type;
6301: TYPE org_independent_flag IS TABLE OF mtl_cross_references_b.org_independent_flag%type;
6302:

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

6295: --for mtl_cross_references_b
6296: --bug# 4539578
6297:
6298: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
6299: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;
6300: TYPE cross_reference IS TABLE OF mtl_cross_references_b.cross_reference%type;
6301: TYPE org_independent_flag IS TABLE OF mtl_cross_references_b.org_independent_flag%type;
6302:
6303:

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

6296: --bug# 4539578
6297:
6298: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
6299: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;
6300: TYPE cross_reference IS TABLE OF mtl_cross_references_b.cross_reference%type;
6301: TYPE org_independent_flag IS TABLE OF mtl_cross_references_b.org_independent_flag%type;
6302:
6303:
6304: t_organization_id org_id;

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

6297:
6298: TYPE org_id IS TABLE OF mtl_cross_references_b.organization_id%type;
6299: TYPE cross_reference_type IS TABLE OF mtl_cross_references_b.cross_reference_type%type;
6300: TYPE cross_reference IS TABLE OF mtl_cross_references_b.cross_reference%type;
6301: TYPE org_independent_flag IS TABLE OF mtl_cross_references_b.org_independent_flag%type;
6302:
6303:
6304: t_organization_id org_id;
6305: t_cross_ref_type cross_reference_type;

Line 7915: FROM MTL_CROSS_REFERENCES_B CR,

7911: t_organization_id,
7912: t_cross_ref_type,
7913: t_cross_ref,
7914: t_org_independent_flag
7915: FROM MTL_CROSS_REFERENCES_B CR,
7916: BOM_CTO_SRC_ORGS BCSO
7917: WHERE (CR.ORGANIZATION_ID = bcso.ORGANIZATION_ID OR CR.ORGANIZATION_ID IS NULL)
7918: AND CR.INVENTORY_ITEM_ID = PMODELID
7919: AND BCSO.MODEL_ITEM_ID = PMODELID

Line 7923: FROM MTL_CROSS_REFERENCES_B

7919: AND BCSO.MODEL_ITEM_ID = PMODELID
7920: AND BCSO.LINE_ID = PLINEID
7921: AND NOT EXISTS
7922: ( SELECT NULL
7923: FROM MTL_CROSS_REFERENCES_B
7924: WHERE INVENTORY_ITEM_ID = PCONFIGID
7925: AND ( ORGANIZATION_ID = bcso.ORGANIZATION_ID OR ORGANIZATION_ID IS NULL) -- bugfix 1960994: added OR condition
7926: );
7927:

Line 7931: INSERT INTO MTL_CROSS_REFERENCES_B

7927:
7928: IF t_cross_ref_type.count <> 0 THEN
7929:
7930: FORALL i IN 1..t_cross_ref_type.count
7931: INSERT INTO MTL_CROSS_REFERENCES_B
7932: (
7933: INVENTORY_ITEM_ID
7934: ,ORGANIZATION_ID
7935: ,CROSS_REFERENCE_TYPE

Line 7990: ,MTL_CROSS_REFERENCES_B_S.NEXTVAL --CROSS_REFERENCE_ID

7986: ,NULL --SOURCE_SYSTEM_ID
7987: ,1 --OBJECT_VERSION_NUMBER
7988: ,NULL --UOM_CODE due to ER#3215422. do not copy uom_code and revision_id attribute for mtl_cross_references
7989: ,NULL --REVISION_ID due to ER#3215422. do not copy uom_code and revision_id attribute for mtl_cross_references
7990: ,MTL_CROSS_REFERENCES_B_S.NEXTVAL --CROSS_REFERENCE_ID
7991: ,0 --EPC_GTIN_SERIAL
7992: ,NULL --ATTRIBUTE1
7993: ,NULL --ATTRIBUTE2
7994: ,NULL --ATTRIBUTE3

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

8007: ,NULL --ATTRIBUTE_CATEGORY
8008: );
8009:
8010: IF PG_DEBUG <> 0 THEN
8011: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_cross_references_b',2);
8012: oe_debug_pub.add('Create_Item: ' || '# of inserted rows mtl_cross_references_b'||sql%rowcount,2);
8013:
8014: END IF;
8015:

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

8008: );
8009:
8010: IF PG_DEBUG <> 0 THEN
8011: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_cross_references_b',2);
8012: oe_debug_pub.add('Create_Item: ' || '# of inserted rows mtl_cross_references_b'||sql%rowcount,2);
8013:
8014: END IF;
8015:
8016: INSERT INTO mtl_cross_references_tl (

Line 8037: mtl_cross_references_b mtl_cross,

8033: mtl_cross.cross_reference_id,
8034: l.language_code,
8035: userenv('lang')
8036: FROM fnd_languages l,
8037: mtl_cross_references_b mtl_cross,
8038: mtl_system_items_tl mtl
8039: WHERE mtl_cross.inventory_item_id = pConfigId
8040: AND mtl_cross.inventory_item_id = mtl.inventory_item_id
8041: AND mtl_cross.organization_id = mtl.organization_id