DBA Data[Home] [Help]

APPS.GMF_MIGRATION dependencies on IC_LOTS_MST_MIG

Line 4378: ic_lots_mst_mig b

4374: a.inventory_item_id,
4375: b.lot_number,
4376: a.organization_id
4377: FROM gmf_lot_costs a,
4378: ic_lots_mst_mig b
4379: WHERE a.lot_id = b.lot_id
4380: AND nvl(b.additional_status_lot,0) = 1
4381: AND (
4382: (a.cost_type_id IS NOT NULL AND a.cost_mthd_code IS NOT NULL)

Line 5136: ic_lots_mst_mig b

5132: a.legal_entity_id,
5133: b.lot_number,
5134: a.organization_id
5135: FROM gmf_lot_cost_adjustments a,
5136: ic_lots_mst_mig b
5137: WHERE a.lot_id = b.lot_id
5138: AND nvl(b.additional_status_lot,0) = 1
5139: AND (
5140: (a.cost_type_id IS NOT NULL AND a.cost_mthd_code IS NOT NULL)

Line 5776: ic_lots_mst_mig b

5772: b.lot_number,
5773: a.organization_id,
5774: a.resource_uom
5775: FROM gmf_lot_cost_burdens a,
5776: ic_lots_mst_mig b
5777: WHERE a.lot_id = b.lot_id
5778: AND nvl(b.additional_status_lot,0) = 1
5779: AND (
5780: (a.cost_type_id IS NOT NULL AND a.cost_mthd_code IS NOT NULL)

Line 9008: ic_lots_mst_mig c,

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
9012: AND a.period_id = i.prior_period_id