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_LOTS_MST_MIG

Line 4401: ic_lots_mst_mig b

4397: a.inventory_item_id,
4398: b.lot_number,
4399: a.organization_id
4400: FROM gmf_lot_costs a,
4401: ic_lots_mst_mig b
4402: WHERE a.lot_id = b.lot_id
4403: AND nvl(b.additional_status_lot,0) = 1
4404: AND (
4405: (a.cost_type_id IS NOT NULL AND a.cost_mthd_code IS NOT NULL)

Line 5159: ic_lots_mst_mig b

5155: a.legal_entity_id,
5156: b.lot_number,
5157: a.organization_id
5158: FROM gmf_lot_cost_adjustments a,
5159: ic_lots_mst_mig b
5160: WHERE a.lot_id = b.lot_id
5161: AND nvl(b.additional_status_lot,0) = 1
5162: AND (
5163: (a.cost_type_id IS NOT NULL AND a.cost_mthd_code IS NOT NULL)

Line 5799: ic_lots_mst_mig b

5795: b.lot_number,
5796: a.organization_id,
5797: a.resource_uom
5798: FROM gmf_lot_cost_burdens a,
5799: ic_lots_mst_mig b
5800: WHERE a.lot_id = b.lot_id
5801: AND nvl(b.additional_status_lot,0) = 1
5802: AND (
5803: (a.cost_type_id IS NOT NULL AND a.cost_mthd_code IS NOT NULL)

Line 9054: FROM ic_lots_mst_mig c

9050: AND b.period = p_period
9051: AND b.whse_code = p_whse_code
9052: AND NOT EXISTS (
9053: SELECT 'X'
9054: FROM ic_lots_mst_mig c
9055: WHERE c.item_id = b.item_id
9056: AND c.lot_id = b.lot_id
9057: AND c.whse_code = b.whse_code
9058: /* AND c.location = b.location Bug 13942118 */

Line 9224: /* ic_lots_mst_mig c, Bug 13942118 */

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
9228: WHERE a.whse_code = i.whse_code

Line 9225: (SELECT DISTINCT item_id, lot_id, whse_code, lot_number FROM ic_lots_mst_mig) c, /* Bug 13942118 */

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
9228: WHERE a.whse_code = i.whse_code
9229: AND a.period_id = i.prior_period_id