DBA Data[Home] [Help]

APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on STANDARD

Line 102: WIP_NONSTANDARD CONSTANT INTEGER := 3;

98: M_FLOW_SCHEDULES CONSTANT INTEGER := 27;
99: M_ATP_ADJUSTMENT CONSTANT INTEGER := 60;
100:
101: WIP_DISCRETE CONSTANT INTEGER := 1; /* WIP_DISCRETE_JOB */
102: WIP_NONSTANDARD CONSTANT INTEGER := 3;
103:
104:
105: JOB_UNRELEASED CONSTANT INTEGER := 1;/* job status code*/
106: JOB_RELEASED CONSTANT INTEGER := 3;

Line 1314: SELECT NVL(cst.standard_cost, 0)

1310: v_counter NUMBER;
1311: v_bucket_size NUMBER;
1312: v_res_cost NUMBER := 0;
1313: cursor res_cost is
1314: SELECT NVL(cst.standard_cost, 0)
1315: FROM msc_system_items cst
1316: WHERE cst.inventory_item_id = activity_rec.assembly_item_id
1317: AND cst.organization_id = activity_rec.org_id
1318: AND cst.sr_instance_id = activity_rec.instance_id