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_RTG_OI_UTIL dependencies on MTL_PARAMETERS

Line 95: FROM MTL_PARAMETERS MP1

91: this also needed if Organization_id is given and code is not given*/
92:
93: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
94: SET organization_code = (SELECT organization_code
95: FROM MTL_PARAMETERS MP1
96: WHERE mp1.organization_id = BORI.organization_id)
97: WHERE process_flag = 1
98: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
99: AND organization_id is not null

Line 107: FROM MTL_PARAMETERS MP2

103: ( (p_batch_id IS NULL) AND (BORI.batch_id IS NULL) )
104: OR ( p_batch_id = BORI.batch_id )
105: )
106: AND exists (SELECT 'x'
107: FROM MTL_PARAMETERS MP2
108: WHERE mp2.organization_id = BORI.organization_id);
109:
110: stmt_num := 3;
111: /* Update Organization_ids if organization code is given org id is null.

Line 116: FROM MTL_PARAMETERS mp1

112: Orgnaization_id information is needed in the next steps */
113:
114: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
115: SET organization_id = (SELECT organization_id
116: FROM MTL_PARAMETERS mp1
117: WHERE mp1.organization_code = BORI.organization_code)
118: WHERE process_flag = 1
119: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
120: AND organization_id is null

Line 520: FROM MTL_PARAMETERS mp1

516: this also needed if Organization_id is given and code is not given*/
517:
518: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
519: SET organization_code = (SELECT organization_code
520: FROM MTL_PARAMETERS mp1
521: WHERE mp1.organization_id = BOSI.organization_id)
522: WHERE process_flag = 1
523: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
524: AND organization_id is not null

Line 531: FROM MTL_PARAMETERS mp2

527: ( (p_batch_id IS NULL) AND (BOSI.batch_id IS NULL) )
528: OR ( p_batch_id = BOSI.batch_id )
529: )
530: AND exists (SELECT 'x'
531: FROM MTL_PARAMETERS mp2
532: WHERE mp2.organization_id = BOSI.organization_id);
533:
534:
535:

Line 542: FROM MTL_PARAMETERS mp1

538: Orgnaization_id information is needed in the next steps */
539:
540: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
541: SET organization_id = (SELECT organization_id
542: FROM MTL_PARAMETERS mp1
543: WHERE mp1.organization_code = BOSI.organization_code)
544: WHERE process_flag = 1
545: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
546: AND organization_id is null

Line 1081: FROM MTL_PARAMETERS mp1

1077: this also needed if Organization_id is given and code is not given*/
1078:
1079: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1080: SET organization_code = (SELECT organization_code
1081: FROM MTL_PARAMETERS mp1
1082: WHERE mp1.organization_id = BORI.organization_id)
1083: WHERE process_flag = 1
1084: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1085: AND organization_id is not null

Line 1092: FROM MTL_PARAMETERS mp2

1088: ( (p_batch_id IS NULL) AND (BORI.batch_id IS NULL) )
1089: OR ( p_batch_id = BORI.batch_id )
1090: )
1091: AND exists (SELECT 'x'
1092: FROM MTL_PARAMETERS mp2
1093: WHERE mp2.organization_id = BORI.organization_id);
1094:
1095:
1096:

Line 1103: FROM MTL_PARAMETERS mp1

1099: Orgnaization_id information is needed in the next steps */
1100:
1101: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1102: SET organization_id = (SELECT organization_id
1103: FROM MTL_PARAMETERS mp1
1104: WHERE mp1.organization_code = BORI.organization_code)
1105: WHERE process_flag = 1
1106: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1107: AND organization_id is null

Line 1358: FROM MTL_PARAMETERS mp1

1354: this also needed if Organization_id is given and code is not given*/
1355:
1356: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1357: SET organization_code = (SELECT organization_code
1358: FROM MTL_PARAMETERS mp1
1359: WHERE mp1.organization_id = BSORI.organization_id)
1360: WHERE process_flag = 1
1361: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1362: AND organization_id is not null

Line 1369: FROM MTL_PARAMETERS mp2

1365: ( (p_batch_id IS NULL) AND (BSORI.batch_id IS NULL) )
1366: OR ( p_batch_id = BSORI.batch_id )
1367: )
1368: AND exists (SELECT 'x'
1369: FROM MTL_PARAMETERS mp2
1370: WHERE mp2.organization_id = BSORI.organization_id);
1371:
1372:
1373:

Line 1380: FROM MTL_PARAMETERS mp1

1376: Orgnaization_id information is needed in the next steps */
1377:
1378: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1379: SET organization_id = (SELECT organization_id
1380: FROM MTL_PARAMETERS mp1
1381: WHERE mp1.organization_code = BSORI.organization_code)
1382: WHERE process_flag = 1
1383: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1384: AND organization_id is null

Line 1652: FROM MTL_PARAMETERS mp1

1648: this also needed if orgnaization_id is given and code is not given*/
1649:
1650: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1651: SET organization_code = (SELECT organization_code
1652: FROM MTL_PARAMETERS mp1
1653: WHERE mp1.organization_id = BONI.organization_id)
1654: WHERE process_flag = 1
1655: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1656: AND organization_id is not null

Line 1663: FROM MTL_PARAMETERS mp2

1659: ( (p_batch_id IS NULL) AND (BONI.batch_id IS NULL) )
1660: OR ( p_batch_id = BONI.batch_id )
1661: )
1662: AND exists (SELECT 'x'
1663: FROM MTL_PARAMETERS mp2
1664: WHERE mp2.organization_id = BONI.organization_id);
1665:
1666:
1667:

Line 1674: FROM MTL_PARAMETERS mp1

1670: Orgnaization_id information is needed in the next steps */
1671:
1672: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1673: SET organization_id = (SELECT organization_id
1674: FROM MTL_PARAMETERS mp1
1675: WHERE mp1.organization_code = BONI.organization_code)
1676: WHERE process_flag = 1
1677: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1678: AND organization_id is null

Line 1862: FROM MTL_PARAMETERS MP1

1858: this also needed if Organization_id is given and code is not given*/
1859:
1860: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI
1861: SET organization_code = (SELECT organization_code
1862: FROM MTL_PARAMETERS MP1
1863: WHERE mp1.organization_id = MRIRI.organization_id)
1864: WHERE process_flag = 1
1865: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1866: AND organization_id is not null

Line 1873: FROM MTL_PARAMETERS MP2

1869: ( (p_batch_id IS NULL) AND (MRIRI.batch_id IS NULL) )
1870: OR ( p_batch_id = MRIRI.batch_id )
1871: )
1872: AND exists (SELECT 'x'
1873: FROM MTL_PARAMETERS MP2
1874: WHERE mp2.organization_id = MRIRI.organization_id);
1875:
1876:
1877:

Line 1884: FROM MTL_PARAMETERS mp1

1880: Orgnaization_id information is needed in the next steps */
1881:
1882: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI
1883: SET organization_id = (SELECT organization_id
1884: FROM MTL_PARAMETERS mp1
1885: WHERE mp1.organization_code = MRIRI.organization_code)
1886: WHERE process_flag = 1
1887: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
1888: AND organization_id is null