[Home] [Help]
342: l_sql_str := l_sql_str||'inventory_item_id, item_number, instance_id, instance_number, ';
343: l_sql_str := l_sql_str||'serial_number, lot_number, quantity, uom, ';
344: l_sql_str := l_sql_str||'immediate_disposition_code, immediate_type, secondary_disposition_code, ';
345: l_sql_str := l_sql_str||'secondary_type, status_code, status, condition_id, condition_code, item_group_id, item_group_name ';
346: l_sql_str := l_sql_str||'FROM ahl_prd_dispositions_v DIS ';
347:
348: l_where_str := ' workorder_id = (:b' || l_bind_index || ')';
349: l_conditions(l_bind_index) := p_workorder_id;
350: l_bind_index := l_bind_index + 1;
846: SEV.NAME SEVERITY_NAME,
847: INC.PROBLEM_CODE,
848: PCODE.MEANING PROBLEM_MEANING,
849: INC.SUMMARY
850: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_MC_PATH_POSITIONS pp,
851: CS_INCIDENTS_ALL_VL INC, CS_INCIDENT_SEVERITIES_VL SEV,
852: FND_LOOKUP_VALUES_VL PCODE
853: WHERE disp.path_pos_common_id = pp.path_pos_common_id
854: AND pp.path_position_id = p_path_position_id
993: SEV.NAME SEVERITY_NAME,
994: INC.PROBLEM_CODE,
995: PCODE.MEANING PROBLEM_MEANING,
996: INC.SUMMARY
997: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_MC_PATH_POSITIONS pp,
998: CS_INCIDENTS_ALL_VL INC,
999: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE
1000: WHERE disp.path_pos_common_id =pp.path_pos_common_id
1001: AND pp.path_position_id = p_path_position_id
1138: SEV.NAME SEVERITY_NAME,
1139: INC.PROBLEM_CODE,
1140: PCODE.MEANING PROBLEM_MEANING,
1141: INC.SUMMARY
1142: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_MC_PATH_POSITIONS pp,
1143: CS_INCIDENTS_ALL_VL INC,
1144: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE,
1145: AHL_PART_CHANGES_V PC
1146: WHERE disp.path_pos_common_id =pp.path_pos_common_id
1290: SEV.NAME SEVERITY_NAME,
1291: INC.PROBLEM_CODE,
1292: PCODE.MEANING PROBLEM_MEANING,
1293: INC.SUMMARY
1294: FROM AHL_PRD_DISPOSITIONS_V disp, CS_INCIDENTS_ALL_VL INC,
1295: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE
1296: WHERE disp.workorder_id = p_workorder_id
1297: AND disp.instance_id = p_instance_id
1298: AND (disp.status_code NOT IN ('COMPLETE', 'TERMINATED'))
1558: --
1559: --AnRaj: Changed for Performance Bug#4911881
1560: CURSOR get_disp_rec_csr (p_disp_id IN NUMBER) IS
1561: /* SELECT *
1562: FROM AHL_PRD_DISPOSITIONS_V
1563: WHERE disposition_id = p_disp_id;
1564: */
1565: SELECT B.status_code,
1566: B.immediate_disposition_code,
1865: /*
1866: SELECT disp.inventory_item_id, disp.item_number, disp.workorder_id,
1867: vi.organization_id, disp.path_position_id, disp.quantity, disp.uom,
1868: disp.wo_operation_id
1869: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_WORKORDERS wo, AHL_VISITS_B VI
1870: --the organization_id in ahl_prd_dispostions_b is not necessary to be the same as the job org,
1871: --especially when the disposition is for a non empty position(instance''s last_vld_org_id), but
1872: --here we need the job organization.
1873: WHERE disp.workorder_id = wo.workorder_id
1881: disp.path_position_id,
1882: disp.quantity,
1883: disp.uom,
1884: disp.wo_operation_id
1885: from ahl_prd_dispositions_vl disp,
1886: mtl_system_items_kfv mtl,
1887: ahl_workorders wo,
1888: ahl_visits_b vi
1889: where disp.workorder_id = wo.workorder_id
1895: /*
1896: SELECT disp.inventory_item_id, disp.item_number, disp.workorder_id,
1897: wo.organization_id, disp.path_position_id, disp.quantity, disp.uom,
1898: disp.wo_operation_id
1899: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_WORKORDERS_V wo
1900: --the organization_id in ahl_prd_dispostions_b is not necessary to be the same as the job org,
1901: --especially when the disposition is for a non empty position(instance's last_vld_org_id), but
1902: --here we need the job organization.
1903: WHERE disp.workorder_id = wo.workorder_id