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_ITEM_MST_B_MIG

Line 44: FROM ic_item_mst_b_mig

40: p_Item_id IN NUMBER
41: )
42: IS
43: SELECT inventory_item_id
44: FROM ic_item_mst_b_mig
45: WHERE item_id = p_item_id
46: AND inventory_item_id IS NOT NULL
47: AND ROWNUM = 1;
48:

Line 3987: FROM ic_item_mst_b_mig y,

3983: )
3984: = (
3985: SELECT z.master_organization_id,
3986: y.inventory_item_id
3987: FROM ic_item_mst_b_mig y,
3988: mtl_parameters z,
3989: hr_organization_information hoi
3990: WHERE y.item_id = a.item_id
3991: AND y.organization_id = z.organization_id

Line 4244: ic_item_mst_b_mig y

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)
4248: )

Line 4802: FROM ic_item_mst_b_mig y,

4798: =
4799: (
4800: SELECT z.master_organization_id,
4801: y.inventory_item_id
4802: FROM ic_item_mst_b_mig y,
4803: mtl_parameters z,
4804: hr_organization_information hoi
4805: WHERE y.item_id = a.item_id
4806: AND y.organization_id = z.organization_id

Line 4999: ic_item_mst_b_mig y

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)
5003: )

Line 5627: ic_item_mst_b_mig y

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)
5631: )

Line 6039: -- ic_item_mst_b_mig y

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)
6043: -- )

Line 6061: ic_item_mst_b_mig y

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)
6065: )

Line 6090: ic_item_mst_b_mig y

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)
6094: )

Line 9223: ic_item_mst_b_mig b,

9219: NULL program_application_id,
9220: NULL program_id,
9221: NULL program_update_date
9222: FROM ic_perd_bal a,
9223: ic_item_mst_b_mig b,
9224: /* ic_lots_mst_mig c, Bug 13942118 */
9225: (SELECT DISTINCT item_id, lot_id, whse_code, lot_number FROM ic_lots_mst_mig) c, /* Bug 13942118 */
9226: ic_loct_mst d,
9227: mtl_secondary_inventories e

Line 9277: ic_item_mst_b_mig b,

9273: NULL program_application_id,
9274: NULL program_id,
9275: NULL program_update_date
9276: FROM ic_perd_bal a,
9277: ic_item_mst_b_mig b,
9278: ic_loct_mst d,
9279: mtl_secondary_inventories e
9280: WHERE a.whse_code = i.whse_code
9281: AND a.period_id = i.prior_period_id

Line 10029: FROM ic_item_mst_b_mig y,

10025: )
10026: = (
10027: SELECT z.master_organization_id,
10028: y.inventory_item_id
10029: FROM ic_item_mst_b_mig y,
10030: mtl_parameters z,
10031: hr_organization_information hoi
10032: WHERE y.item_id = a.item_id
10033: AND y.organization_id = z.organization_id

Line 10751: FROM ic_item_mst_b_mig y,

10747: =
10748: (
10749: SELECT z.master_organization_id,
10750: y.inventory_item_id
10751: FROM ic_item_mst_b_mig y,
10752: mtl_parameters z,
10753: hr_organization_information hoi
10754: WHERE y.item_id = a.item_id
10755: AND y.organization_id = z.organization_id

Line 11021: FROM ic_item_mst_b_mig y

11017: ) x
11018: WHERE NOT EXISTS
11019: (
11020: SELECT 'X'
11021: FROM ic_item_mst_b_mig y
11022: WHERE y.item_id = x.item_id
11023: AND y.organization_id = x.organization_id
11024: AND NVL(y.migrated_ind,0) = 1
11025: );

Line 11410: FROM ic_item_mst_b_mig y,

11406: )
11407: = (
11408: SELECT z.master_organization_id,
11409: y.inventory_item_id
11410: FROM ic_item_mst_b_mig y,
11411: mtl_parameters z,
11412: hr_organization_information hoi
11413: WHERE y.item_id = a.item_id
11414: AND y.organization_id = z.organization_id

Line 11506: FROM ic_item_mst_b_mig y,

11502: )
11503: = (
11504: SELECT z.master_organization_id,
11505: y.inventory_item_id
11506: FROM ic_item_mst_b_mig y,
11507: mtl_parameters z,
11508: hr_organization_information hoi,
11509: cm_rlup_ctl x
11510: WHERE y.item_id = a.item_id