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

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

Line 533: FROM MTL_PARAMETERS mp2

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

Line 544: FROM MTL_PARAMETERS mp1

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

Line 1083: FROM MTL_PARAMETERS mp1

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

Line 1094: FROM MTL_PARAMETERS mp2

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

Line 1105: FROM MTL_PARAMETERS mp1

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

Line 1360: FROM MTL_PARAMETERS mp1

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

Line 1371: FROM MTL_PARAMETERS mp2

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

Line 1382: FROM MTL_PARAMETERS mp1

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

Line 1654: FROM MTL_PARAMETERS mp1

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

Line 1665: FROM MTL_PARAMETERS mp2

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

Line 1676: FROM MTL_PARAMETERS mp1

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

Line 1864: FROM MTL_PARAMETERS MP1

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

Line 1875: FROM MTL_PARAMETERS MP2

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

Line 1886: FROM MTL_PARAMETERS mp1

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