APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on STANDARD

Line 122: WIP_NONSTANDARD CONSTANT INTEGER := 3;

118: M_EXTERNAL_RO CONSTANT INTEGER := 74;
119: M_MAINTENANCE_WO_AGG CONSTANT INTEGER := 92;/*USAF Supplemental*/
120:
121: WIP_DISCRETE CONSTANT INTEGER := 1; /* WIP_DISCRETE_JOB */
122: WIP_NONSTANDARD CONSTANT INTEGER := 3;
123:
124:
125: JOB_UNRELEASED CONSTANT INTEGER := 1;/* job status code*/
126: JOB_RELEASED CONSTANT INTEGER := 3;

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

1485: v_counter NUMBER;
1486: v_bucket_size NUMBER;
1487: v_res_cost NUMBER := 0;
1488: cursor res_cost is
1489: SELECT NVL(cst.standard_cost, 0)
1490: FROM msc_system_items cst
1491: WHERE cst.inventory_item_id = activity_rec.assembly_item_id
1492: AND cst.organization_id = activity_rec.org_id
1493: AND cst.sr_instance_id = activity_rec.instance_id