DBA Data[Home] [Help]

APPS.INV_COST_GROUP_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 1741: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq

1737: IF p_lpn_id IS NULL THEN
1738: IF p_serial_number IS NULL THEN
1739: SELECT ccg.cost_group_id, ccg.cost_group
1740: INTO x_cost_group_id, x_cost_group
1741: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq
1742: WHERE ccg.cost_group_id = moq.cost_group_id
1743: AND (moq.lot_number = p_lot_number
1744: OR (p_lot_number IS NULL AND moq.lot_number IS NULL))
1745: AND (moq.revision = p_revision