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 589: FROM MTL_PARAMETERS mp1

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

Line 600: FROM MTL_PARAMETERS mp2

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

Line 611: FROM MTL_PARAMETERS mp1

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

Line 1151: FROM MTL_PARAMETERS mp1

1147: this also needed if Organization_id is given and code is not given*/
1148:
1149: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1150: SET organization_code = (SELECT organization_code
1151: FROM MTL_PARAMETERS mp1
1152: WHERE mp1.organization_id = BRDI.organization_id)
1153: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1154: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1155: AND organization_id is not null

Line 1162: FROM MTL_PARAMETERS mp2

1158: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
1159: OR ( p_batch_id = BRDI.batch_id )
1160: )
1161: AND exists (SELECT 'x'
1162: FROM MTL_PARAMETERS mp2
1163: WHERE mp2.organization_id = BRDI.organization_id);
1164:
1165:
1166:

Line 1173: FROM MTL_PARAMETERS mp1

1169: Orgnaization_id information is needed in the next steps */
1170:
1171: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1172: SET organization_id = (SELECT organization_id
1173: FROM MTL_PARAMETERS mp1
1174: WHERE mp1.organization_code = BRDI.organization_code)
1175: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1176: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1177: AND organization_id is null

Line 1421: FROM MTL_PARAMETERS mp1

1417: this also needed if Organization_id is given and code is not given*/
1418:
1419: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1420: SET organization_code = (SELECT organization_code
1421: FROM MTL_PARAMETERS mp1
1422: WHERE mp1.organization_id = BSCI.organization_id)
1423: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1424: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1425: AND organization_id is not null

Line 1432: FROM MTL_PARAMETERS mp2

1428: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1429: OR ( p_batch_id = BSCI.batch_id )
1430: )
1431: AND exists (SELECT 'x'
1432: FROM MTL_PARAMETERS mp2
1433: WHERE mp2.organization_id = BSCI.organization_id);
1434:
1435:
1436:

Line 1443: FROM MTL_PARAMETERS mp1

1439: Orgnaization_id information is needed in the next steps */
1440:
1441: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1442: SET organization_id = (SELECT organization_id
1443: FROM MTL_PARAMETERS mp1
1444: WHERE mp1.organization_code = BSCI.organization_code)
1445: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1446: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1447: AND organization_id is null

Line 1738: FROM MTL_PARAMETERS mp1

1734: this also needed if orgnaization_id is given and code is not given*/
1735:
1736: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1737: SET organization_code = (SELECT organization_code
1738: FROM MTL_PARAMETERS mp1
1739: WHERE mp1.organization_id = BCOI.organization_id)
1740: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1741: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1742: AND organization_id is not null

Line 1749: FROM MTL_PARAMETERS mp2

1745: ( (p_batch_id IS NULL) AND (BCOI.batch_id IS NULL) )
1746: OR ( p_batch_id = BCOI.batch_id )
1747: )
1748: AND exists (SELECT 'x'
1749: FROM MTL_PARAMETERS mp2
1750: WHERE mp2.organization_id = BCOI.organization_id);
1751:
1752:
1753:

Line 1760: FROM MTL_PARAMETERS mp1

1756: Orgnaization_id information is needed in the next steps */
1757:
1758: UPDATE BOM_COMPONENT_OPS_INTERFACE BCOI
1759: SET organization_id = (SELECT organization_id
1760: FROM MTL_PARAMETERS mp1
1761: WHERE mp1.organization_code = BCOI.organization_code)
1762: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1763: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1764: AND organization_id is null

Line 1952: FROM MTL_PARAMETERS MP1

1948: this also needed if Organization_id is given and code is not given*/
1949:
1950: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
1951: SET organization_code = (SELECT organization_code
1952: FROM MTL_PARAMETERS MP1
1953: WHERE mp1.organization_id = MIRI.organization_id)
1954: WHERE process_flag = 1
1955: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1956: AND organization_id is not null

Line 1959: FROM MTL_PARAMETERS MP2

1955: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1956: AND organization_id is not null
1957: AND MIRI.set_process_id = l_set_process_id
1958: AND exists (SELECT 'x'
1959: FROM MTL_PARAMETERS MP2
1960: WHERE mp2.organization_id = MIRI.organization_id);
1961:
1962:
1963:

Line 1970: FROM MTL_PARAMETERS mp1

1966: Orgnaization_id information is needed in the next steps */
1967:
1968: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
1969: SET organization_id = (SELECT organization_id
1970: FROM MTL_PARAMETERS mp1
1971: WHERE mp1.organization_code = MIRI.organization_code)
1972: WHERE process_flag = 1
1973: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1974: AND organization_id is null

Line 2226: FROM MTL_PARAMETERS mp1

2222: Orgnaization_id information is needed in the next steps */
2223:
2224: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2225: SET organization_id = (SELECT organization_id
2226: FROM MTL_PARAMETERS mp1
2227: WHERE mp1.organization_code = BICI.organization_code)
2228: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2229: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
2230: AND organization_code is not null

Line 2237: FROM MTL_PARAMETERS mp2

2233: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2234: OR ( p_batch_id = BICI.batch_id )
2235: )
2236: AND exists (SELECT 'x'
2237: FROM MTL_PARAMETERS mp2
2238: WHERE mp2.organization_code = BICI.organization_code);
2239:
2240: /* Update the Assembly_item_number */
2241: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

Line 2607: FROM MTL_PARAMETERS mp1

2603: this also needed if Organization_id is given and code is not given*/
2604:
2605: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2606: SET organization_code = (SELECT organization_code
2607: FROM MTL_PARAMETERS mp1
2608: WHERE mp1.organization_id = BRDI.organization_id)
2609: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2610: AND organization_id is not null
2611: AND

Line 2617: FROM MTL_PARAMETERS mp2

2613: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
2614: OR ( p_batch_id = BRDI.batch_id )
2615: )
2616: AND exists (SELECT 'x'
2617: FROM MTL_PARAMETERS mp2
2618: WHERE mp2.organization_id = BRDI.organization_id);
2619:
2620:
2621:

Line 2627: FROM MTL_PARAMETERS mp1

2623: Orgnaization_id information is needed in the next steps */
2624:
2625: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2626: SET organization_id = (SELECT organization_id
2627: FROM MTL_PARAMETERS mp1
2628: WHERE mp1.organization_code = BRDI.organization_code)
2629: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2630: AND organization_id is null
2631: AND organization_code is not null

Line 2873: FROM MTL_PARAMETERS mp1

2869: this also needed if Organization_id is given and code is not given*/
2870:
2871: UPDATE bom_sub_comps_interface BSCI
2872: SET organization_code = (SELECT organization_code
2873: FROM MTL_PARAMETERS mp1
2874: WHERE mp1.organization_id = BSCI.organization_id)
2875: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2876: AND organization_id is not null
2877: AND

Line 2883: FROM MTL_PARAMETERS mp2

2879: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
2880: OR ( p_batch_id = BSCI.batch_id )
2881: )
2882: AND exists (SELECT 'x'
2883: FROM MTL_PARAMETERS mp2
2884: WHERE mp2.organization_id = BSCI.organization_id);
2885:
2886:
2887:

Line 2893: FROM MTL_PARAMETERS mp1

2889: Orgnaization_id information is needed in the next steps */
2890:
2891: UPDATE bom_sub_comps_interface BSCI
2892: SET organization_id = (SELECT organization_id
2893: FROM MTL_PARAMETERS mp1
2894: WHERE mp1.organization_code = BSCI.organization_code)
2895: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2896: AND organization_id is null
2897: AND organization_code is not null