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 3964: FROM ic_item_mst_b_mig y,

3960: )
3961: = (
3962: SELECT z.master_organization_id,
3963: y.inventory_item_id
3964: FROM ic_item_mst_b_mig y,
3965: mtl_parameters z,
3966: hr_organization_information hoi
3967: WHERE y.item_id = a.item_id
3968: AND y.organization_id = z.organization_id

Line 4221: ic_item_mst_b_mig y

4217: = (
4218: SELECT decode(x.cost_organization_id, -1, -1, y.organization_id),
4219: y.inventory_item_id
4220: FROM ic_whse_mst x,
4221: ic_item_mst_b_mig y
4222: WHERE x.whse_code = a.whse_code
4223: AND y.item_id = a.item_id
4224: AND y.organization_id = NVL(DECODE(x.cost_organization_id, -1, x.mtl_organization_id, x.cost_organization_id), x.mtl_organization_id)
4225: )

Line 4779: FROM ic_item_mst_b_mig y,

4775: =
4776: (
4777: SELECT z.master_organization_id,
4778: y.inventory_item_id
4779: FROM ic_item_mst_b_mig y,
4780: mtl_parameters z,
4781: hr_organization_information hoi
4782: WHERE y.item_id = a.item_id
4783: AND y.organization_id = z.organization_id

Line 4976: ic_item_mst_b_mig y

4972: = (
4973: SELECT decode(x.cost_organization_id, -1, -1, y.organization_id),
4974: y.inventory_item_id
4975: FROM ic_whse_mst x,
4976: ic_item_mst_b_mig y
4977: WHERE x.whse_code = a.whse_code
4978: AND y.item_id = a.item_id
4979: AND y.organization_id = NVL(DECODE(x.cost_organization_id, -1, x.mtl_organization_id, x.cost_organization_id), x.mtl_organization_id)
4980: )

Line 5604: ic_item_mst_b_mig y

5600: = (
5601: SELECT decode(x.cost_organization_id, -1, -1, y.organization_id),
5602: y.inventory_item_id
5603: FROM ic_whse_mst x,
5604: ic_item_mst_b_mig y
5605: WHERE x.whse_code = a.whse_code
5606: AND y.item_id = a.item_id
5607: AND y.organization_id = NVL(DECODE(x.cost_organization_id, -1, x.mtl_organization_id, x.cost_organization_id), x.mtl_organization_id)
5608: )

Line 6016: ic_item_mst_b_mig y

6012: = (
6013: SELECT y.organization_id,
6014: y.inventory_item_id
6015: FROM ic_whse_mst x,
6016: ic_item_mst_b_mig y
6017: WHERE x.whse_code = a.whse_code
6018: AND y.item_id = a.item_id
6019: AND y.organization_id = DECODE(NVL(x.subinventory_ind_flag, 'N'), 'Y', x.organization_id, x.mtl_organization_id)
6020: )

Line 9007: ic_item_mst_b_mig b,

9003: NULL,
9004: NULL,
9005: NULL
9006: FROM ic_perd_bal a,
9007: ic_item_mst_b_mig b,
9008: ic_lots_mst_mig c,
9009: ic_loct_mst d,
9010: mtl_secondary_inventories e
9011: WHERE a.whse_code = i.whse_code

Line 9702: FROM ic_item_mst_b_mig y,

9698: )
9699: = (
9700: SELECT z.master_organization_id,
9701: y.inventory_item_id
9702: FROM ic_item_mst_b_mig y,
9703: mtl_parameters z,
9704: hr_organization_information hoi
9705: WHERE y.item_id = a.item_id
9706: AND y.organization_id = z.organization_id

Line 10422: FROM ic_item_mst_b_mig y,

10418: =
10419: (
10420: SELECT z.master_organization_id,
10421: y.inventory_item_id
10422: FROM ic_item_mst_b_mig y,
10423: mtl_parameters z,
10424: hr_organization_information hoi
10425: WHERE y.item_id = a.item_id
10426: AND y.organization_id = z.organization_id

Line 10691: FROM ic_item_mst_b_mig y

10687: ) x
10688: WHERE NOT EXISTS
10689: (
10690: SELECT 'X'
10691: FROM ic_item_mst_b_mig y
10692: WHERE y.item_id = x.item_id
10693: AND y.organization_id = x.organization_id
10694: );
10695:

Line 11079: FROM ic_item_mst_b_mig y,

11075: )
11076: = (
11077: SELECT z.master_organization_id,
11078: y.inventory_item_id
11079: FROM ic_item_mst_b_mig y,
11080: mtl_parameters z,
11081: hr_organization_information hoi
11082: WHERE y.item_id = a.item_id
11083: AND y.organization_id = z.organization_id

Line 11175: FROM ic_item_mst_b_mig y,

11171: )
11172: = (
11173: SELECT z.master_organization_id,
11174: y.inventory_item_id
11175: FROM ic_item_mst_b_mig y,
11176: mtl_parameters z,
11177: hr_organization_information hoi,
11178: cm_rlup_ctl x
11179: WHERE y.item_id = a.item_id