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.GMF_MIGRATION dependencies on IC_WHSE_MST

Line 304: FROM hr_organization_information a, ic_whse_mst b

300: p_whse_code IN VARCHAR2
301: )
302: IS
303: SELECT to_number(a.org_information2) legal_entity_id
304: FROM hr_organization_information a, ic_whse_mst b
305: WHERE a.organization_id = decode(nvl(b.subinventory_ind_flag, 'N'), 'Y', b.organization_id, b.mtl_organization_id)
306: AND b.whse_code = p_whse_code
307: AND a.org_information_context = 'Accounting Information';
308:

Line 1690: ic_whse_mst b

1686: )
1687: IS
1688: select a.co_code
1689: from sy_orgn_mst a,
1690: ic_whse_mst b
1691: where a.orgn_code = b.orgn_code
1692: and b.whse_code = p_whse_code;
1693:
1694: BEGIN

Line 3287: ic_whse_mst l

3283: cm_mthd_mst h,
3284: gl_plcy_mst i,
3285: sy_orgn_mst j,
3286: cm_cmpt_dtl k,
3287: ic_whse_mst l
3288: WHERE g.co_code IS NOT NULL
3289: AND l.whse_code = k.whse_code
3290: AND j.orgn_code = l.orgn_code
3291: AND i.co_code = j.co_code

Line 3385: ic_whse_mst l

3381: cm_mthd_mst h,
3382: gl_plcy_mst i,
3383: sy_orgn_mst j,
3384: cm_adjs_dtl k,
3385: ic_whse_mst l
3386: WHERE g.co_code IS NOT NULL
3387: AND l.whse_code = k.whse_code
3388: AND j.orgn_code = l.orgn_code
3389: AND i.co_code = j.co_code

Line 3751: ic_whse_mst b,

3747: FROM (
3748: SELECT a.item_id,
3749: nvl(DECODE(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id), DECODE(NVL(b.subinventory_ind_flag,'N'), 'Y', b.organization_id, b.mtl_organization_id)) organization_id
3750: FROM gmf_burden_percentages a,
3751: ic_whse_mst b,
3752: ic_whse_mst c
3753: WHERE a.item_id IS NOT NULL
3754: AND b.orgn_code = a.orgn_code
3755: AND c.whse_code(+) = a.whse_code

Line 3752: ic_whse_mst c

3748: SELECT a.item_id,
3749: nvl(DECODE(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id), DECODE(NVL(b.subinventory_ind_flag,'N'), 'Y', b.organization_id, b.mtl_organization_id)) organization_id
3750: FROM gmf_burden_percentages a,
3751: ic_whse_mst b,
3752: ic_whse_mst c
3753: WHERE a.item_id IS NOT NULL
3754: AND b.orgn_code = a.orgn_code
3755: AND c.whse_code(+) = a.whse_code
3756: );

Line 3853: ic_whse_mst e

3849: a.gl_category_id,
3850: a.cost_category_id,
3851: a.gl_prod_line_category_id
3852: FROM gmf_burden_percentages a,
3853: ic_whse_mst e
3854: WHERE a.orgn_code IS NOT NULL
3855: AND a.whse_code IS NULL
3856: AND a.orgn_code = e.orgn_code
3857: AND e.mtl_organization_id IS NOT NULL

Line 3907: FROM ic_whse_mst x, sy_orgn_mst y

3903: )
3904: = (
3905: SELECT DECODE(a.whse_code, null, DECODE(NVL(Y.INVENTORY_ORG_IND,'N'), 'Y', y.organization_id, NULL), DECODE(NVL(x.subinventory_ind_flag,'N'), 'Y', x.organization_id, x.mtl_organization_id)),
3906: DECODE(a.delete_mark, 1, a.delete_mark, DECODE(a.whse_code, null, DECODE(NVL(Y.INVENTORY_ORG_IND,'N'), 'Y', 0, 1), DECODE(NVL(x.subinventory_ind_flag,'N'), 'Y', 1, 0)))
3907: FROM ic_whse_mst x, sy_orgn_mst y
3908: WHERE x.whse_code = nvl(a.whse_code, x.whse_code)
3909: and y.orgn_code = DECODE(a.whse_code, NULL, a.orgn_code, x.orgn_code)
3910: AND ROWNUM = 1
3911: )*/

Line 3928: FROM ic_whse_mst x, sy_orgn_mst y

3924: )
3925: = (
3926: SELECT DECODE(a.whse_code, null, DECODE(NVL(Y.INVENTORY_ORG_IND,'N'), 'Y', y.organization_id, NULL), DECODE(NVL(x.subinventory_ind_flag,'N'), 'Y', x.organization_id, x.mtl_organization_id)),
3927: DECODE(a.delete_mark, 1, a.delete_mark, DECODE(a.whse_code, null, DECODE(NVL(Y.INVENTORY_ORG_IND,'N'), 'Y', 0, 1), DECODE(NVL(x.subinventory_ind_flag,'N'), 'Y', 1, 0)))
3928: FROM ic_whse_mst x, sy_orgn_mst y
3929: WHERE x.whse_code = nvl(a.whse_code, x.whse_code)
3930: and y.orgn_code = DECODE(a.whse_code, NULL, a.orgn_code, x.orgn_code)
3931: AND ROWNUM = 1
3932: )

Line 4243: FROM ic_whse_mst x,

4239: )
4240: = (
4241: SELECT decode(x.cost_organization_id, -1, -1, y.organization_id),
4242: y.inventory_item_id
4243: FROM ic_whse_mst x,
4244: ic_item_mst_b_mig y
4245: WHERE x.whse_code = a.whse_code
4246: AND y.item_id = a.item_id
4247: AND y.organization_id = NVL(DECODE(x.cost_organization_id, -1, x.mtl_organization_id, x.cost_organization_id), x.mtl_organization_id)

Line 4998: FROM ic_whse_mst x,

4994: )
4995: = (
4996: SELECT decode(x.cost_organization_id, -1, -1, y.organization_id),
4997: y.inventory_item_id
4998: FROM ic_whse_mst x,
4999: ic_item_mst_b_mig y
5000: WHERE x.whse_code = a.whse_code
5001: AND y.item_id = a.item_id
5002: AND y.organization_id = NVL(DECODE(x.cost_organization_id, -1, x.mtl_organization_id, x.cost_organization_id), x.mtl_organization_id)

Line 5626: FROM ic_whse_mst x,

5622: )
5623: = (
5624: SELECT decode(x.cost_organization_id, -1, -1, y.organization_id),
5625: y.inventory_item_id
5626: FROM ic_whse_mst x,
5627: ic_item_mst_b_mig y
5628: WHERE x.whse_code = a.whse_code
5629: AND y.item_id = a.item_id
5630: AND y.organization_id = NVL(DECODE(x.cost_organization_id, -1, x.mtl_organization_id, x.cost_organization_id), x.mtl_organization_id)

Line 5967: ic_whse_mst b

5963: FROM (
5964: SELECT a.item_id,
5965: DECODE(NVL(b.subinventory_ind_flag,'N'), 'Y', b.organization_id, b.mtl_organization_id) organization_id
5966: FROM gl_aloc_bas a,
5967: ic_whse_mst b
5968: WHERE a.item_id IS NOT NULL
5969: AND b.whse_code = a.whse_code
5970: );
5971:

Line 6038: -- FROM ic_whse_mst x,

6034: -- )
6035: -- = (
6036: -- SELECT y.organization_id,
6037: -- y.inventory_item_id
6038: -- FROM ic_whse_mst x,
6039: -- ic_item_mst_b_mig y
6040: -- WHERE x.whse_code = a.whse_code
6041: -- AND y.item_id = a.item_id
6042: -- AND y.organization_id = DECODE(NVL(x.subinventory_ind_flag, 'N'), 'Y', x.organization_id, x.mtl_organization_id)

Line 6060: FROM ic_whse_mst x,

6056: )
6057: = (
6058: SELECT y.organization_id,
6059: y.inventory_item_id
6060: FROM ic_whse_mst x,
6061: ic_item_mst_b_mig y
6062: WHERE x.whse_code = a.whse_code
6063: AND y.item_id = a.item_id
6064: AND y.organization_id = DECODE(NVL(x.subinventory_ind_flag, 'N'), 'Y', x.organization_id, x.mtl_organization_id)

Line 6089: FROM ic_whse_mst x,

6085: )
6086: = (
6087: SELECT y.organization_id,
6088: y.inventory_item_id
6089: FROM ic_whse_mst x,
6090: ic_item_mst_b_mig y
6091: WHERE x.whse_code = a.whse_code
6092: AND y.item_id = a.item_id
6093: AND y.organization_id = DECODE(NVL(x.subinventory_ind_flag, 'N'), 'Y', x.organization_id, x.mtl_organization_id)

Line 6536: TYPE t_mtl_organization_id IS TABLE OF IC_WHSE_MST.MTL_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

6532: TYPE t_ar_trx_type_id IS TABLE OF GL_ACCT_MAP.AR_TRX_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
6533: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
6534: TYPE t_inventory_org_ind IS TABLE OF SY_ORGN_MST.INVENTORY_ORG_IND%TYPE INDEX BY BINARY_INTEGER;
6535: TYPE t_organization_id IS TABLE OF SY_ORGN_MST.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
6536: TYPE t_mtl_organization_id IS TABLE OF IC_WHSE_MST.MTL_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
6537: TYPE t_subinventory_ind_flag IS TABLE OF IC_WHSE_MST.SUBINVENTORY_IND_FLAG%TYPE INDEX BY BINARY_INTEGER;
6538: TYPE t_acct_no IS TABLE OF GL_ACCT_MST.ACCT_NO%TYPE INDEX BY BINARY_INTEGER;
6539: TYPE t_source_type IS TABLE OF GL_ACCT_MAP.SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6540:

Line 6537: TYPE t_subinventory_ind_flag IS TABLE OF IC_WHSE_MST.SUBINVENTORY_IND_FLAG%TYPE INDEX BY BINARY_INTEGER;

6533: TYPE t_rowid IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
6534: TYPE t_inventory_org_ind IS TABLE OF SY_ORGN_MST.INVENTORY_ORG_IND%TYPE INDEX BY BINARY_INTEGER;
6535: TYPE t_organization_id IS TABLE OF SY_ORGN_MST.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
6536: TYPE t_mtl_organization_id IS TABLE OF IC_WHSE_MST.MTL_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
6537: TYPE t_subinventory_ind_flag IS TABLE OF IC_WHSE_MST.SUBINVENTORY_IND_FLAG%TYPE INDEX BY BINARY_INTEGER;
6538: TYPE t_acct_no IS TABLE OF GL_ACCT_MST.ACCT_NO%TYPE INDEX BY BINARY_INTEGER;
6539: TYPE t_source_type IS TABLE OF GL_ACCT_MAP.SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6540:
6541: /******************

Line 6730: ic_whse_mst d

6726: a.accu_map_id
6727: FROM gl_accu_map a,
6728: gl_accu_mst b,
6729: sy_orgn_mst c,
6730: ic_whse_mst d
6731: WHERE a.co_code = p_co_code
6732: AND b.acctg_unit_id = a.acctg_unit_id
6733: AND c.orgn_code(+) = a.orgn_code
6734: AND d.whse_code(+) = a.whse_code

Line 6751: FROM ic_whse_mst a

6747: SELECT a.whse_code,
6748: a.whse_name,
6749: NVL(a.subinventory_ind_flag,'N') subinventory_ind_flag,
6750: a.mtl_organization_id
6751: FROM ic_whse_mst a
6752: WHERE a.orgn_code = p_orgn_code
6753: AND NOT EXISTS
6754: (
6755: SELECT 'X'

Line 6775: FROM ic_whse_mst a

6771: SELECT a.whse_code,
6772: a.whse_name,
6773: NVL(a.subinventory_ind_flag,'N') subinventory_ind_flag,
6774: a.mtl_organization_id
6775: FROM ic_whse_mst a
6776: WHERE a.orgn_code = p_orgn_code
6777: AND NOT EXISTS
6778: (
6779: SELECT 'X'

Line 7798: ic_whse_mst d '

7794: EXECUTE IMMEDIATE X_sqlcolumns ||
7795: ' FROM gl_acct_map a,
7796: gl_acct_mst b,
7797: sy_orgn_mst c,
7798: ic_whse_mst d '
7799: ||
7800: X_sqlwhere
7801: ||
7802: X_sqlordby

Line 9008: ic_whse_mst e,

9004: ic_cldr_dtl b,
9005: ic_cldr_dtl c,
9006: org_acct_periods d,
9007: hr_organization_information hoi,
9008: ic_whse_mst e,
9009: gl_ledgers f
9010: WHERE a.co_code = b.orgn_code /* Bug 10339562 - Changed a.orgn_code to a.co_code */
9011: AND c.orgn_code = a.co_code /* Bug 10339562 - Changed a.orgn_code to a.co_code */
9012: AND e.orgn_code = a.orgn_code

Line 9953: ic_whse_mst c

9949: SELECT a.item_id,
9950: decode(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id) organization_id
9951: FROM cm_cmpt_mtl a,
9952: sy_orgn_mst b,
9953: ic_whse_mst c
9954: WHERE a.item_id IS NOT NULL
9955: AND a.co_code = b.co_code
9956: AND b.orgn_code = c.orgn_code
9957: AND nvl(c.subinventory_ind_flag, 'N') <> 'Y'

Line 10735: FROM ic_whse_mst w1

10731: AND w.co_code = z.co_code
10732: ),
10733: a.source_organization_id = (
10734: SELECT DECODE(NVL(subinventory_ind_flag,'N'), 'Y', organization_id, mtl_organization_id)
10735: FROM ic_whse_mst w1
10736: WHERE w1.whse_code = a.whse_code
10737: )
10738: WHERE (a.legal_entity_id IS NULL AND a.orgn_code IS NOT NULL)
10739: OR (a.organization_id IS NULL AND a.orgn_code IS NOT NULL)

Line 10812: ic_whse_mst e

10808: a.source_organization_id,
10809: a.master_organization_id,
10810: a.legal_entity_id
10811: FROM cm_whse_src a,
10812: ic_whse_mst e
10813: WHERE NOT EXISTS (
10814: SELECT 'X'
10815: FROM cm_whse_src x
10816: WHERE x.legal_entity_id = a.legal_entity_id

Line 10939: ic_whse_mst b

10935: (
10936: SELECT a.item_id,
10937: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10938: FROM cm_acst_led a,
10939: ic_whse_mst b
10940: WHERE a.item_id IS NOT NULL
10941: AND a.whse_code = b.whse_code
10942: UNION
10943: SELECT a.item_id,

Line 10946: ic_whse_mst b

10942: UNION
10943: SELECT a.item_id,
10944: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10945: FROM cm_adjs_dtl a,
10946: ic_whse_mst b
10947: WHERE a.item_id IS NOT NULL
10948: AND a.whse_code = b.whse_code
10949: UNION
10950: SELECT a.item_id,

Line 10953: ic_whse_mst b

10949: UNION
10950: SELECT a.item_id,
10951: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10952: FROM cm_brdn_dtl a,
10953: ic_whse_mst b
10954: WHERE a.item_id IS NOT NULL
10955: AND a.whse_code = b.whse_code
10956: UNION
10957: SELECT a.item_id,

Line 10960: ic_whse_mst b

10956: UNION
10957: SELECT a.item_id,
10958: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10959: FROM cm_cmpt_dtl a,
10960: ic_whse_mst b
10961: WHERE a.item_id IS NOT NULL
10962: AND a.whse_code = b.whse_code
10963: UNION
10964: SELECT a.item_id,

Line 10967: ic_whse_mst b

10963: UNION
10964: SELECT a.item_id,
10965: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10966: FROM cm_scst_led a,
10967: ic_whse_mst b
10968: WHERE a.item_id IS NOT NULL
10969: AND a.whse_code = b.whse_code
10970: UNION
10971: SELECT a.item_id,

Line 10974: ic_whse_mst b,

10970: UNION
10971: SELECT a.item_id,
10972: nvl(DECODE(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id), DECODE(NVL(b.subinventory_ind_flag,'N'), 'Y', b.organization_id, b.mtl_organization_id)) organization_id
10973: FROM cm_whse_src a,
10974: ic_whse_mst b,
10975: ic_whse_mst c
10976: WHERE a.item_id IS NOT NULL
10977: AND b.orgn_code = a.orgn_code
10978: AND c.whse_code(+) = a.whse_code

Line 10975: ic_whse_mst c

10971: SELECT a.item_id,
10972: nvl(DECODE(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id), DECODE(NVL(b.subinventory_ind_flag,'N'), 'Y', b.organization_id, b.mtl_organization_id)) organization_id
10973: FROM cm_whse_src a,
10974: ic_whse_mst b,
10975: ic_whse_mst c
10976: WHERE a.item_id IS NOT NULL
10977: AND b.orgn_code = a.orgn_code
10978: AND c.whse_code(+) = a.whse_code
10979: UNION

Line 10983: ic_whse_mst b

10979: UNION
10980: SELECT a.item_id,
10981: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10982: FROM gl_item_cst a,
10983: ic_whse_mst b
10984: WHERE a.item_id IS NOT NULL
10985: AND a.whse_code = b.whse_code
10986: UNION
10987: SELECT a.item_id,

Line 10991: ic_whse_mst c

10987: SELECT a.item_id,
10988: DECODE(NVL(c.subinventory_ind_flag,'N'), 'Y', c.organization_id, c.mtl_organization_id) organization_id
10989: FROM gmf_lot_costed_items a,
10990: sy_orgn_mst b,
10991: ic_whse_mst c
10992: WHERE a.item_id IS NOT NULL
10993: AND a.co_code = b.co_Code
10994: AND b.orgn_code = c.orgn_code
10995: AND nvl(c.subinventory_ind_flag,'N') <> 'Y'

Line 11000: ic_whse_mst b

10996: UNION
10997: SELECT a.item_id,
10998: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10999: FROM gmf_lot_Costs a,
11000: ic_whse_mst b
11001: WHERE a.item_id IS NOT NULL
11002: AND a.whse_code = b.whse_code
11003: UNION
11004: SELECT a.item_id,

Line 11007: ic_whse_mst b

11003: UNION
11004: SELECT a.item_id,
11005: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
11006: FROM gmf_lot_Cost_adjustments a,
11007: ic_whse_mst b
11008: WHERE a.item_id IS NOT NULL
11009: AND a.whse_code = b.whse_code
11010: UNION
11011: SELECT a.item_id,

Line 11014: ic_whse_mst b

11010: UNION
11011: SELECT a.item_id,
11012: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
11013: FROM gmf_lot_Cost_burdens a,
11014: ic_whse_mst b
11015: WHERE a.item_id IS NOT NULL
11016: AND a.whse_code = b.whse_code
11017: ) x
11018: WHERE NOT EXISTS

Line 12111: CURSOR cur_ic_whse_mst

12107:
12108: /**********
12109: * Cursors *
12110: **********/
12111: CURSOR cur_ic_whse_mst
12112: IS
12113: SELECT a.whse_code,
12114: NVL(a.subinventory_ind_flag, 'N') subinventory_ind_flag,
12115: a.mtl_organization_id,

Line 12126: FROM ic_whse_mst a,

12122: DECODE(COUNT(d.cost_whse_code), 0, 'N', 'Y') cost_warehouse,
12123: DECODE(COUNT(f.cost_whse_code), 0, 'N', 'Y') same_plant_cost_warehouse,
12124: DECODE(SUM(DECODE(f.cost_whse_code, NULL, 0, DECODE(NVL(c.subinventory_ind_flag, 'N'), 'N', 0, 1))), 0, 'N', 'Y') cost_whse_is_subinv,
12125: DECODE(COUNT(e.whse_code), 0, 'N', 'Y') inv_warehouse
12126: FROM ic_whse_mst a,
12127: sy_orgn_mst b,
12128: ic_whse_mst c,
12129: cm_whse_asc d,
12130: cm_whse_asc e,

Line 12128: ic_whse_mst c,

12124: DECODE(SUM(DECODE(f.cost_whse_code, NULL, 0, DECODE(NVL(c.subinventory_ind_flag, 'N'), 'N', 0, 1))), 0, 'N', 'Y') cost_whse_is_subinv,
12125: DECODE(COUNT(e.whse_code), 0, 'N', 'Y') inv_warehouse
12126: FROM ic_whse_mst a,
12127: sy_orgn_mst b,
12128: ic_whse_mst c,
12129: cm_whse_asc d,
12130: cm_whse_asc e,
12131: cm_whse_asc f
12132: WHERE a.orgn_code = b.orgn_code

Line 12172: * Migrate warehouse records in IC_WHSE_MST to facilitate Cost Warehouse Derivation *

12168: p_app_short_name => 'GMA'
12169: );
12170:
12171: /***********************************************************************************
12172: * Migrate warehouse records in IC_WHSE_MST to facilitate Cost Warehouse Derivation *
12173: ***********************************************************************************/
12174: FOR i IN cur_ic_whse_mst LOOP
12175: IF nvl(i.subinventory_ind_flag, 'N') <> 'Y' THEN /* Migrated as Inventory Organization */
12176: l_costing_organization_id := i.mtl_organization_id;

Line 12174: FOR i IN cur_ic_whse_mst LOOP

12170:
12171: /***********************************************************************************
12172: * Migrate warehouse records in IC_WHSE_MST to facilitate Cost Warehouse Derivation *
12173: ***********************************************************************************/
12174: FOR i IN cur_ic_whse_mst LOOP
12175: IF nvl(i.subinventory_ind_flag, 'N') <> 'Y' THEN /* Migrated as Inventory Organization */
12176: l_costing_organization_id := i.mtl_organization_id;
12177: ELSE /* Migrated as Sub-Inventory */
12178: IF nvl(i.Subinventory_count,0) = 1 THEN /* Only Warehouse under the plant Migrated as Sub-Inventory */

Line 12201: UPDATE ic_whse_mst a

12197: END IF;
12198: END IF;
12199: END IF;
12200:
12201: UPDATE ic_whse_mst a
12202: SET a.cost_organization_id = l_costing_organization_id
12203: WHERE a.whse_code = i.whse_code;
12204: END LOOP;
12205:

Line 12212: FROM ic_whse_mst x

12208: a.organization_id
12209: )
12210: = (
12211: SELECT x.cost_organization_id
12212: FROM ic_whse_mst x
12213: WHERE x.whse_code = a.whse_code
12214: ),
12215: (
12216: a.cost_organization_id

Line 12220: FROM ic_whse_mst x

12216: a.cost_organization_id
12217: )
12218: = (
12219: SELECT x.cost_organization_id
12220: FROM ic_whse_mst x
12221: WHERE x.whse_code = a.cost_whse_code
12222: );
12223:
12224: UPDATE cm_whse_asc a