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.BOM_OPEN_INTERFACE_UTL dependencies on MTL_PARAMETERS

Line 91: FROM MTL_PARAMETERS MP1

87: this also needed if Organization_id is given and code is not given*/
88:
89: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
90: SET organization_code = (SELECT organization_code
91: FROM MTL_PARAMETERS MP1
92: WHERE mp1.organization_id = BBMI.organization_id)
93: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
94: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,G_NoOp)
95: AND organization_id is not null

Line 102: FROM MTL_PARAMETERS MP2

98: ( (p_batch_id IS NULL) AND (BBMI.batch_id IS NULL) )
99: OR ( p_batch_id = BBMI.batch_id )
100: )
101: AND exists (SELECT 'x'
102: FROM MTL_PARAMETERS MP2
103: WHERE mp2.organization_id = BBMI.organization_id);
104:
105:
106:

Line 113: FROM MTL_PARAMETERS mp1

109: Orgnaization_id information is needed in the next steps */
110:
111: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
112: SET organization_id = (SELECT organization_id
113: FROM MTL_PARAMETERS mp1
114: WHERE mp1.organization_code = BBMI.organization_code)
115: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
116: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,G_NoOp)
117: AND organization_id is null

Line 213: FROM MTL_PARAMETERS mp1

209: /* Assign common_organization_code if common_organization_id is populated */
210:
211: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
212: SET common_org_code = (SELECT organization_code
213: FROM MTL_PARAMETERS mp1
214: WHERE mp1.organization_id = BBMI.common_organization_id)
215: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
216: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,G_NoOp)
217: AND common_organization_id is not null

Line 224: FROM MTL_PARAMETERS mp2

220: ( (p_batch_id IS NULL) AND (BBMI.batch_id IS NULL) )
221: OR ( p_batch_id = BBMI.batch_id )
222: )
223: AND exists (SELECT 'x'
224: FROM MTL_PARAMETERS mp2
225: WHERE mp2.organization_id = BBMI.common_organization_id);
226:
227:
228:

Line 235: FROM MTL_PARAMETERS MP1

231: Orgnaization_id information is needed in the next steps */
232:
233: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
234: SET common_organization_id = (SELECT organization_id
235: FROM MTL_PARAMETERS MP1
236: WHERE mp1.organization_code = BBMI.common_org_code)
237: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
238: AND upper(transaction_type) in (G_Create, G_Delete, G_Update,G_NoOp)
239: AND common_organization_id is null

Line 591: FROM MTL_PARAMETERS mp1

587: this also needed if Organization_id is given and code is not given*/
588:
589: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
590: SET organization_code = (SELECT organization_code
591: FROM MTL_PARAMETERS mp1
592: WHERE mp1.organization_id = BICI.organization_id)
593: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
594: AND change_notice is null --added for bug 9673701
595: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 603: FROM MTL_PARAMETERS mp2

599: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
600: OR ( p_batch_id = BICI.batch_id )
601: )
602: AND exists (SELECT 'x'
603: FROM MTL_PARAMETERS mp2
604: WHERE mp2.organization_id = BICI.organization_id);
605:
606:
607:

Line 614: FROM MTL_PARAMETERS mp1

610: Orgnaization_id information is needed in the next steps */
611:
612: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
613: SET organization_id = (SELECT organization_id
614: FROM MTL_PARAMETERS mp1
615: WHERE mp1.organization_code = BICI.organization_code)
616: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
617: AND change_notice is null --added for bug 9673701
618: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1171: FROM MTL_PARAMETERS mp1

1167: this also needed if Organization_id is given and code is not given*/
1168:
1169: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1170: SET organization_code = (SELECT organization_code
1171: FROM MTL_PARAMETERS mp1
1172: WHERE mp1.organization_id = BRDI.organization_id)
1173: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1174: AND change_notice is null --added for bug 9673701
1175: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1183: FROM MTL_PARAMETERS mp2

1179: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
1180: OR ( p_batch_id = BRDI.batch_id )
1181: )
1182: AND exists (SELECT 'x'
1183: FROM MTL_PARAMETERS mp2
1184: WHERE mp2.organization_id = BRDI.organization_id);
1185:
1186:
1187:

Line 1194: FROM MTL_PARAMETERS mp1

1190: Orgnaization_id information is needed in the next steps */
1191:
1192: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1193: SET organization_id = (SELECT organization_id
1194: FROM MTL_PARAMETERS mp1
1195: WHERE mp1.organization_code = BRDI.organization_code)
1196: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1197: AND change_notice is null --added for bug 9673701
1198: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1450: FROM MTL_PARAMETERS mp1

1446: this also needed if Organization_id is given and code is not given*/
1447:
1448: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1449: SET organization_code = (SELECT organization_code
1450: FROM MTL_PARAMETERS mp1
1451: WHERE mp1.organization_id = BSCI.organization_id)
1452: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1453: AND change_notice is null --added for bug 9673701
1454: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1462: FROM MTL_PARAMETERS mp2

1458: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1459: OR ( p_batch_id = BSCI.batch_id )
1460: )
1461: AND exists (SELECT 'x'
1462: FROM MTL_PARAMETERS mp2
1463: WHERE mp2.organization_id = BSCI.organization_id);
1464:
1465:
1466:

Line 1473: FROM MTL_PARAMETERS mp1

1469: Orgnaization_id information is needed in the next steps */
1470:
1471: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1472: SET organization_id = (SELECT organization_id
1473: FROM MTL_PARAMETERS mp1
1474: WHERE mp1.organization_code = BSCI.organization_code)
1475: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1476: AND change_notice is null --added for bug 9673701
1477: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1776: FROM MTL_PARAMETERS mp1

1772: this also needed if orgnaization_id is given and code is not given*/
1773:
1774: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1775: SET organization_code = (SELECT organization_code
1776: FROM MTL_PARAMETERS mp1
1777: WHERE mp1.organization_id = BCOI.organization_id)
1778: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1779: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1780: AND organization_id is not null

Line 1787: FROM MTL_PARAMETERS mp2

1783: ( (p_batch_id IS NULL) AND (BCOI.batch_id IS NULL) )
1784: OR ( p_batch_id = BCOI.batch_id )
1785: )
1786: AND exists (SELECT 'x'
1787: FROM MTL_PARAMETERS mp2
1788: WHERE mp2.organization_id = BCOI.organization_id);
1789:
1790:
1791:

Line 1798: FROM MTL_PARAMETERS mp1

1794: Orgnaization_id information is needed in the next steps */
1795:
1796: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1797: SET organization_id = (SELECT organization_id
1798: FROM MTL_PARAMETERS mp1
1799: WHERE mp1.organization_code = BCOI.organization_code)
1800: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1801: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1802: AND organization_id is null

Line 1990: FROM MTL_PARAMETERS MP1

1986: this also needed if Organization_id is given and code is not given*/
1987:
1988: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
1989: SET organization_code = (SELECT organization_code
1990: FROM MTL_PARAMETERS MP1
1991: WHERE mp1.organization_id = MIRI.organization_id)
1992: WHERE process_flag = 1
1993: AND change_notice is null --added for bug 9673701
1994: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1998: FROM MTL_PARAMETERS MP2

1994: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1995: AND organization_id is not null
1996: AND MIRI.set_process_id = l_set_process_id
1997: AND exists (SELECT 'x'
1998: FROM MTL_PARAMETERS MP2
1999: WHERE mp2.organization_id = MIRI.organization_id);
2000:
2001:
2002:

Line 2009: FROM MTL_PARAMETERS mp1

2005: Orgnaization_id information is needed in the next steps */
2006:
2007: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
2008: SET organization_id = (SELECT organization_id
2009: FROM MTL_PARAMETERS mp1
2010: WHERE mp1.organization_code = MIRI.organization_code)
2011: WHERE process_flag = 1
2012: AND change_notice is null --added for bug 9673701
2013: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 2270: FROM MTL_PARAMETERS mp1

2266: Orgnaization_id information is needed in the next steps */
2267:
2268: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2269: SET organization_id = (SELECT organization_id
2270: FROM MTL_PARAMETERS mp1
2271: WHERE mp1.organization_code = BICI.organization_code)
2272: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2273: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
2274: AND organization_code is not null

Line 2281: FROM MTL_PARAMETERS mp2

2277: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2278: OR ( p_batch_id = BICI.batch_id )
2279: )
2280: AND exists (SELECT 'x'
2281: FROM MTL_PARAMETERS mp2
2282: WHERE mp2.organization_code = BICI.organization_code);
2283:
2284: /* Update the Assembly_item_number */
2285: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

Line 2651: FROM MTL_PARAMETERS mp1

2647: this also needed if Organization_id is given and code is not given*/
2648:
2649: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2650: SET organization_code = (SELECT organization_code
2651: FROM MTL_PARAMETERS mp1
2652: WHERE mp1.organization_id = BRDI.organization_id)
2653: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2654: AND organization_id is not null
2655: AND

Line 2661: FROM MTL_PARAMETERS mp2

2657: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
2658: OR ( p_batch_id = BRDI.batch_id )
2659: )
2660: AND exists (SELECT 'x'
2661: FROM MTL_PARAMETERS mp2
2662: WHERE mp2.organization_id = BRDI.organization_id);
2663:
2664:
2665:

Line 2671: FROM MTL_PARAMETERS mp1

2667: Orgnaization_id information is needed in the next steps */
2668:
2669: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2670: SET organization_id = (SELECT organization_id
2671: FROM MTL_PARAMETERS mp1
2672: WHERE mp1.organization_code = BRDI.organization_code)
2673: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2674: AND organization_id is null
2675: AND organization_code is not null

Line 2917: FROM MTL_PARAMETERS mp1

2913: this also needed if Organization_id is given and code is not given*/
2914:
2915: UPDATE bom_sub_comps_interface BSCI
2916: SET organization_code = (SELECT organization_code
2917: FROM MTL_PARAMETERS mp1
2918: WHERE mp1.organization_id = BSCI.organization_id)
2919: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2920: AND organization_id is not null
2921: AND

Line 2927: FROM MTL_PARAMETERS mp2

2923: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
2924: OR ( p_batch_id = BSCI.batch_id )
2925: )
2926: AND exists (SELECT 'x'
2927: FROM MTL_PARAMETERS mp2
2928: WHERE mp2.organization_id = BSCI.organization_id);
2929:
2930:
2931:

Line 2937: FROM MTL_PARAMETERS mp1

2933: Orgnaization_id information is needed in the next steps */
2934:
2935: UPDATE bom_sub_comps_interface BSCI
2936: SET organization_id = (SELECT organization_id
2937: FROM MTL_PARAMETERS mp1
2938: WHERE mp1.organization_code = BSCI.organization_code)
2939: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2940: AND organization_id is null
2941: AND organization_code is not null