[Home] [Help]
1935: and dpt.order_line_id = oel.line_id
1936: and dpt.repair_line_id = dra.repair_line_id
1937: and dpt.action_type is null
1938: and lv.lookup_type = 'LINE_FLOW_STATUS'
1939: and lv.meaning = OE_LINE_STATUS_PUB.get_line_status(p_line_id => oel.line_id,
1940: p_flow_status_code => oel.flow_status_code)
1941: and
1942: oel.line_id = decode(p_order_line_id,
1943: fnd_api.g_miss_num, oel.line_id,
2240: and edt.order_line_id = oel.line_id
2241: and dpt.repair_line_id = dra.repair_line_id
2242: and dpt.action_type = 'RMA'
2243: and lv.lookup_type = 'LINE_FLOW_STATUS'
2244: and lv.meaning = OE_LINE_STATUS_PUB.get_line_status(p_line_id => oel.line_id,
2245: p_flow_status_code => oel.flow_status_code)
2246: and
2247: oel.line_id = decode(p_order_line_id,
2248: fnd_api.g_miss_num, oel.line_id,
2542: and edt.order_line_id = oel.line_id
2543: and dpt.repair_line_id = dra.repair_line_id
2544: and dpt.action_type = 'RMA_THIRD_PTY'
2545: and lv.lookup_type = 'LINE_FLOW_STATUS'
2546: and lv.meaning = OE_LINE_STATUS_PUB.get_line_status(p_line_id => oel.line_id,
2547: p_flow_status_code => oel.flow_status_code)
2548: and
2549: oel.line_id = decode(p_order_line_id,
2550: fnd_api.g_miss_num, oel.line_id,
2846: and edt.order_line_id = oel.line_id
2847: and dpt.repair_line_id = dra.repair_line_id
2848: and dpt.action_type = 'SHIP'
2849: and lv.lookup_type = 'LINE_FLOW_STATUS'
2850: and lv.meaning = OE_LINE_STATUS_PUB.get_line_status(p_line_id => oel.line_id,
2851: p_flow_status_code => oel.flow_status_code)
2852: and
2853: oel.line_id = decode(p_order_line_id,
2854: fnd_api.g_miss_num, oel.line_id,
3150: and edt.order_line_id = oel.line_id
3151: and dpt.repair_line_id = dra.repair_line_id
3152: and dpt.action_type = 'SHIP_THIRD_PTY'
3153: and lv.lookup_type = 'LINE_FLOW_STATUS'
3154: and lv.meaning = OE_LINE_STATUS_PUB.get_line_status(p_line_id => oel.line_id,
3155: p_flow_status_code => oel.flow_status_code)
3156: and
3157: oel.line_id = decode(p_order_line_id,
3158: fnd_api.g_miss_num, oel.line_id,