[Home] [Help]
889: WO.WIP_ENTITY_ID,
890: WDJ.REBUILD_ITEM_ID,
891: wdj.MAINTENANCE_OBJECT_ID
892: FROM AHL_WORKORDERS WO,
893: WIP_DISCRETE_JOBS WDJ,
894: AHL_VISIT_TASKS_B VTS,
895: AHL_WORKORDERS WO1
896: WHERE WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
897: AND WO.STATUS_CODE NOT IN ('7','12','17','22' ) -- Cancelled,Closed,Draft and Deleted
2140: FROM wip_parameters
2141: WHERE organization_id = p_org_id;
2142:
2143: CURSOR workorder_released_date_csr(p_wip_entity_id IN NUMBER) IS
2144: SELECT DATE_RELEASED FROM WIP_DISCRETE_JOBS
2145: WHERE WIP_ENTITY_ID = p_wip_entity_id;
2146:
2147: -- Lot Number
2148: CURSOR mtl_lot_num_csr (p_org_id In NUMBER,
5032: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
5033: AHL_VISITS_B V,
5034: AHL_VISIT_TASKS_B VT,
5035: CS_INCIDENTS_ALL_B C,
5036: WIP_DISCRETE_JOBS WDJ,
5037: (SELECT ORGANIZATION_ID, NAME FROM HR_ALL_ORGANIZATION_UNITS_TL WHERE LANGUAGE = USERENV('LANG')) ORG,
5038: BOM_DEPARTMENTS B,
5039: AHL_WORKORDER_OPERATIONS O,
5040: MTL_UNITS_OF_MEASURE_VL UOM,
5322: l_bind_index := l_bind_index + 1;
5323: END IF;
5324:
5325: IF (P_prd_Mtltxn_criteria_rec.PRIORITY IS NOT NULL) THEN
5326: l_mtl_txn_dtls := l_mtl_txn_dtls || ', WIP_DISCRETE_JOBS WDJ';
5327: l_mtl_txn_dtls_where := l_mtl_txn_dtls_where || ' AND WDJ.WIP_ENTITY_ID = W.WIP_ENTITY_ID
5328: AND WDJ.PRIORITY = :' || l_bind_index;
5329: l_bind_value_tbl(l_bind_index) := P_prd_Mtltxn_criteria_rec.PRIORITY;
5330: l_bind_index := l_bind_index + 1;
5336: l_bind_index := l_bind_index + 1;
5337: END IF;
5338:
5339: IF (P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME IS NOT NULL) THEN
5340: l_mtl_txn_dtls := l_mtl_txn_dtls || ', WIP_DISCRETE_JOBS WDJ,BOM_DEPARTMENTS B';
5341: l_mtl_txn_dtls_where := l_mtl_txn_dtls_where || ' AND WDJ.WIP_ENTITY_ID = W.WIP_ENTITY_ID
5342: AND WDJ.OWNING_DEPARTMENT = B.DEPARTMENT_ID (+)
5343: AND B.DESCRIPTION LIKE :' || l_bind_index;
5344: l_bind_value_tbl(l_bind_index) := P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME;
5919: AHL_WORKORDERS W,
5920: AHL_VISITS_B V,
5921: AHL_VISIT_TASKS_B VT,
5922: CS_INCIDENTS_ALL_B C,
5923: WIP_DISCRETE_JOBS WDJ,
5924: INV_ORGANIZATION_NAME_V ORG,
5925: BOM_DEPARTMENTS B,
5926: AHL_WORKORDER_OPERATIONS O
5927: WHERE
6255:
6256: END IF;
6257:
6258: IF (P_prd_Mtltxn_criteria_rec.PRIORITY IS NOT NULL) THEN
6259: l_mtl_txn_dtls := l_mtl_txn_dtls || ', WIP_DISCRETE_JOBS WDJ';
6260: l_mtl_txn_dtls_where := l_mtl_txn_dtls_where || ' AND WDJ.WIP_ENTITY_ID = W.WIP_ENTITY_ID
6261: AND WDJ.PRIORITY = :'||l_bind_index;
6262: l_bind_value_tbl(l_bind_index) := P_prd_Mtltxn_criteria_rec.PRIORITY;
6263: l_bind_index := l_bind_index + 1;
6274: l_bind_index := l_bind_index + 1;
6275: END IF;
6276:
6277: IF (P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME IS NOT NULL) THEN
6278: l_mtl_txn_dtls := l_mtl_txn_dtls || ', WIP_DISCRETE_JOBS WDJ,BOM_DEPARTMENTS B';
6279: l_mtl_txn_dtls_where := l_mtl_txn_dtls_where || ' AND WDJ.WIP_ENTITY_ID = W.WIP_ENTITY_ID
6280: AND WDJ.OWNING_DEPARTMENT = B.DEPARTMENT_ID (+)
6281: AND B.DESCRIPTION LIKE :'||l_bind_index;
6282: l_bind_value_tbl(l_bind_index) := P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME;
6820: l_bind_index := l_bind_index + 1;
6821: END IF;
6822:
6823: IF (P_PRD_MTLTXN_CRITERIA_REC.PRIORITY IS NOT NULL) THEN
6824: L_MTL_TXN_DTLS := L_MTL_TXN_DTLS || ', WIP_DISCRETE_JOBS WDJ';
6825: L_MTL_TXN_DTLS_WHERE := L_MTL_TXN_DTLS_WHERE || ' AND WDJ.WIP_ENTITY_ID = W.WIP_ENTITY_ID
6826: AND WDJ.PRIORITY = :' || l_bind_index;
6827: l_bind_value_tbl(l_bind_index) := P_prd_Mtltxn_criteria_rec.PRIORITY;
6828: l_bind_index := l_bind_index + 1;
6834: l_bind_index := l_bind_index + 1;
6835: END IF;
6836:
6837: IF (P_PRD_MTLTXN_CRITERIA_REC.DEPARTMENT_NAME IS NOT NULL) THEN
6838: L_MTL_TXN_DTLS := L_MTL_TXN_DTLS || ', WIP_DISCRETE_JOBS WDJ,BOM_DEPARTMENTS BMD';
6839: L_MTL_TXN_DTLS_WHERE := L_MTL_TXN_DTLS_WHERE || ' AND WDJ.WIP_ENTITY_ID = W.WIP_ENTITY_ID
6840: AND WDJ.OWNING_DEPARTMENT = BMD.DEPARTMENT_ID (+)
6841: AND BMD.DESCRIPTION LIKE :' || l_bind_index;
6842: l_bind_value_tbl(l_bind_index) := P_prd_Mtltxn_criteria_rec.DEPARTMENT_NAME;