APPS.WIP_WS_EMBEDDED_ANALYTICS_PK dependencies on WIP_DISCRETE_JOBS

Line 220: WIP_DISCRETE_JOBS wdj

216: AND wmt.fm_intraoperation_step_type > WIP_CONSTANTS.RUN))))
217: GROUP BY wop.department_id, wmt.shift_start_date, wmt.shift_num, wop.wip_entity_id, wop.operation_seq_num
218:
219: ) completed_info,
220: WIP_DISCRETE_JOBS wdj
221:
222: WHERE wdj.wip_entity_id = completed_info.wip_entity_id
223: AND wdj.organization_id = p_org_id;
224:

Line 349: WIP_DISCRETE_JOBS wdj

345: ) pre_cal
346: ) post_cal
347: GROUP BY post_cal.department_id, post_cal.shift_start_date, post_cal.shift_num, post_cal.wip_entity_id, post_cal.operation_seq_num
348: ) completed_info,
349: WIP_DISCRETE_JOBS wdj
350:
351: WHERE wdj.wip_entity_id = completed_info.wip_entity_id
352: AND wdj.organization_id = p_org_id;
353:

Line 955: WIP_DISCRETE_JOBS wdj

951: AND wwf.INVENTORY_ITEM_ID is NOT NULL AND wwf.OPERATION_SEQ_NUM is NOT NULL
952: GROUP BY wwf.WIP_ENTITY_ID, TRUNC(shift_date),wwf.INVENTORY_ITEM_ID
953: HAVING MIN(FPY_PERCENT) <= 0
954: ) day_sum,
955: WIP_DISCRETE_JOBS wdj
956: WHERE wdj.WIP_ENTITY_ID = day_sum.WIP_ENTITY_ID
957: AND wdj.organization_id = p_org_id) pre_calc;
958: x_return_status := FND_API.G_RET_STS_SUCCESS;
959:

Line 1038: WIP_DISCRETE_JOBS wdj

1034: AND wwf.INVENTORY_ITEM_ID is NOT NULL AND wwf.OPERATION_SEQ_NUM is NOT NULL
1035: GROUP BY wwf.WIP_ENTITY_ID, TRUNC(shift_date),wwf.SHIFT_NUM ,wwf.INVENTORY_ITEM_ID
1036: HAVING MIN(FPY_PERCENT) <= 0
1037: ) day_sum,
1038: WIP_DISCRETE_JOBS wdj
1039: WHERE wdj.WIP_ENTITY_ID = day_sum.WIP_ENTITY_ID
1040: AND wdj.organization_id = p_org_id) pre_calc;
1041: /*
1042: INSERT INTO wip_ws_fpy (

Line 1076: WIP_DISCRETE_JOBS wdj

1072: AND wwf.WIP_ENTITY_ID is NOT NULL AND wwf.DEPARTMENT_ID is NOT NULL
1073: AND wwf.INVENTORY_ITEM_ID is NOT NULL AND wwf.OPERATION_SEQ_NUM is NOT NULL
1074: GROUP BY wwf.WIP_ENTITY_ID, TRUNC(shift_date),wwf.SHIFT_NUM ,wwf.INVENTORY_ITEM_ID
1075: HAVING MIN(FPY_PERCENT) = 0) day_sum,
1076: WIP_DISCRETE_JOBS wdj
1077: WHERE wdj.WIP_ENTITY_ID = day_sum.WIP_ENTITY_ID
1078: AND wdj.organization_id = p_org_id) pre_calc;
1079: */
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1157: WIP_DISCRETE_JOBS wdj

1153: AND wwf.INVENTORY_ITEM_ID is NOT NULL AND wwf.OPERATION_SEQ_NUM is NOT NULL
1154: GROUP BY wwf.WIP_ENTITY_ID, wwf.INVENTORY_ITEM_ID
1155: HAVING MIN(FPY_PERCENT) <= 0
1156: ) day_sum,
1157: WIP_DISCRETE_JOBS wdj
1158: WHERE wdj.WIP_ENTITY_ID = day_sum.WIP_ENTITY_ID
1159: AND wdj.organization_id = p_org_id) pre_calc;
1160: x_return_status := FND_API.G_RET_STS_SUCCESS;
1161:

Line 1238: WIP_DISCRETE_JOBS wdj

1234: AND wwf.INVENTORY_ITEM_ID is NOT NULL AND wwf.OPERATION_SEQ_NUM is NOT NULL
1235: GROUP BY wwf.WIP_ENTITY_ID, wwf.INVENTORY_ITEM_ID, wwf.SHIFT_NUM
1236: HAVING MIN(FPY_PERCENT) <= 0
1237: ) day_sum,
1238: WIP_DISCRETE_JOBS wdj
1239: WHERE wdj.WIP_ENTITY_ID = day_sum.WIP_ENTITY_ID
1240: AND wdj.organization_id = p_org_id) pre_calc;
1241: x_return_status := FND_API.G_RET_STS_SUCCESS;
1242:

Line 2830: from wip_discrete_jobs wdj1

2826: WIP_WS_EMBEDDED_ANALYTICS_PK.get_shift_info_for_date(
2827: wdj1.organization_id, null, null,
2828: nvl(wdj1.date_completed, wdj1.date_closed)) shift_info,
2829: wdj1.*
2830: from wip_discrete_jobs wdj1
2831: where wdj1.date_completed > p_start_date
2832: and wdj1.organization_id = p_org_id
2833: and wdj1.status_type in (WIP_CONSTANTS.CLOSED, WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.COMP_NOCHRG)
2834: and wdj1.quantity_completed > 0) wdj;