DBA Data[Home] [Help]

APPS.MSC_REL_PS_PLAN_PUB dependencies on MSC_REL_PLAN_PUB

Line 4261: NVL(MSC_REL_PLAN_PUB.GET_WIP_SUPPLY_TYPE(s.plan_id, s.sr_instance_id,s.process_seq_id,

4257: decode(md.component_scaling_type,1,NULL,md.component_scaling_type),
4258: decode(l_apps_ver,'4',TO_NUMBER(NULL),'3',TO_NUMBER(NULL),(md.USING_REQUIREMENT_QUANTITY/s.implement_quantity)),
4259: md.component_yield_factor, -- bugbug is this correct?
4260: TO_NUMBER(NULL), --Department_ID
4261: NVL(MSC_REL_PLAN_PUB.GET_WIP_SUPPLY_TYPE(s.plan_id, s.sr_instance_id,s.process_seq_id,
4262: s.inventory_item_id,md.inventory_item_id,s.organization_id),
4263: msi.wip_supply_type),-- ey, see comment below for the same field
4264: md.USING_ASSEMBLY_DEMAND_DATE,
4265: decode(l_apps_ver,'4',TO_NUMBER(NULL),'3',TO_NUMBER(NULL),md.USING_REQUIREMENT_QUANTITY),

Line 4361: /*NVL(MSC_REL_PLAN_PUB.GET_WIP_SUPPLY_TYPE(s.plan_id, s.sr_instance_id,s.process_seq_id,

4357: decode(l_apps_ver,'4',to_number(null),'3',null,icomp.sr_inventory_item_id),
4358: decode(l_apps_ver,'4',to_number(null),'3',TO_NUMBER(NULL),(co.new_order_quantity/s.implement_quantity)),
4359: TO_NUMBER(NULL), --Department_ID
4360: co.wip_supply_type,
4361: /*NVL(MSC_REL_PLAN_PUB.GET_WIP_SUPPLY_TYPE(s.plan_id, s.sr_instance_id,s.process_seq_id,
4362: s.inventory_item_id,co.inventory_item_id,s.organization_id,
4363: md.wip_supply_type), -- ey, wip_supply_type for */
4364: co.new_schedule_date,
4365: decode(l_apps_ver,'4',to_number(null),'3',TO_NUMBER(NULL),co.new_order_quantity),