eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_WF_UPGRADE_UTIL dependencies on OE_ORDER_LINES_ALL

Line 313: update oe_order_lines_all

309: OE_Line_Status_Pub.Get_Ship_Status(to_number(itemkey), l_ship_status);
310:
311: IF (l_ship_status = 'Y') THEN
312: resultout := 'COMPLETE:Y';
313: update oe_order_lines_all
314: set flow_status_code = decode(source_type_code, 'EXTERNAL', 'SHIPPED', 'SHIPPED')
315: where line_id = to_number(itemkey);
316: ELSE
317: resultout := 'COMPLETE:N'; -- Order will get booked via WF

Line 318: update oe_order_lines_all

314: set flow_status_code = decode(source_type_code, 'EXTERNAL', 'SHIPPED', 'SHIPPED')
315: where line_id = to_number(itemkey);
316: ELSE
317: resultout := 'COMPLETE:N'; -- Order will get booked via WF
318: update oe_order_lines_all
319: set flow_status_code = decode(source_type_code, 'EXTERNAL', 'AWAITING_RECEIPT', 'AWAITING_SHIPPING')
320: where line_id = to_number(itemkey);
321:
322: END IF;

Line 399: from oe_order_lines_all

395: if (funcmode = 'RUN') then
396:
397: select source_type_code
398: into l_source_type_code
399: from oe_order_lines_all
400: where line_id = to_number(itemkey);
401:
402: IF nvl(l_source_type_code,'INTERNAL') = 'EXTERNAL' THEN
403: resultout := 'NOTIFIED:#NULL';

Line 479: update oe_order_lines_all

475: OE_LINE_STATUS_PUB.GET_RECEIVED_STATUS(to_number(itemkey), l_received_status);
476:
477: IF (l_received_status = 'Y') THEN
478: resultout := 'COMPLETE:Y';
479: update oe_order_lines_all
480: set flow_status_code = 'RETURNED'
481: where line_id = to_number(itemkey);
482: ELSE
483: resultout := 'COMPLETE:N';

Line 484: update oe_order_lines_all

480: set flow_status_code = 'RETURNED'
481: where line_id = to_number(itemkey);
482: ELSE
483: resultout := 'COMPLETE:N';
484: update oe_order_lines_all
485: set flow_status_code = 'AWAITING_RETURN'
486: where line_id = to_number(itemkey);
487:
488: END IF;

Line 567: from oe_order_lines_all

563:
564: -- Check if return already inspected
565: Select shipped_quantity,fulfilled_quantity
566: into l_shipped_quantity,l_fulfilled_quantity
567: from oe_order_lines_all
568: where line_id = to_number(itemkey);
569:
570:
571: IF (l_shipped_quantity is not NULL and

Line 655: update oe_order_lines_all

651: OE_ORDER_UPGRADE_UTIL.Get_Invoice_Status_Code(to_number(itemkey), l_invoice_interface_status);
652:
653: IF (l_invoice_interface_status = 'COMPLETE') THEN
654: resultout := 'COMPLETE:COMPLETE';
655: update oe_order_lines_all
656: set flow_status_code = 'INVOICED'
657: where line_id = to_number(itemkey);
658: ELSIF (l_invoice_interface_status = 'NOT_ELIGIBLE') THEN
659: resultout := 'COMPLETE:NOT_ELIGIBLE';

Line 663: update oe_order_lines_all

659: resultout := 'COMPLETE:NOT_ELIGIBLE';
660: ELSIF (l_invoice_interface_status = 'RFR-PENDING' OR
661: l_invoice_interface_status = 'MANUAL-PENDING') THEN
662: resultout := 'COMPLETE:PRTL_COMPLETE';
663: update oe_order_lines_all
664: set flow_status_code = 'INVOICED_PARTIAL'
665: where line_id = to_number(itemkey);
666:
667: ELSE

Line 924: update oe_order_lines_all

920: -- Order Line will be scheduled via WF
921: resultout := 'COMPLETE:N';
922: ELSE
923: resultout := 'COMPLETE:Y';
924: update oe_order_lines_all
925: set flow_status_code = 'SCHEDULED'
926: where line_id = to_number(itemkey);
927: END IF;
928:

Line 1033: FROM OE_ORDER_LINES_ALL

1029: resultout := 'COMPLETE:WORK_ORDER_COMPLETE';
1030:
1031: SELECT item_type_code, ato_line_id
1032: INTO l_item_type_code, l_ato_line_id
1033: FROM OE_ORDER_LINES_ALL
1034: WHERE line_id = to_number(itemkey);
1035:
1036: IF l_ato_line_id = to_number(itemkey) AND
1037: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

Line 1040: update oe_order_lines_all

1036: IF l_ato_line_id = to_number(itemkey) AND
1037: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1038: l_item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1039: THEN
1040: update oe_order_lines_all
1041: set flow_status_code = 'BOOKED'
1042: where line_id = to_number(itemkey);
1043: ELSE
1044: update oe_order_lines_all

Line 1044: update oe_order_lines_all

1040: update oe_order_lines_all
1041: set flow_status_code = 'BOOKED'
1042: where line_id = to_number(itemkey);
1043: ELSE
1044: update oe_order_lines_all
1045: set flow_status_code = 'PRODUCTION_COMPLETE'
1046: where line_id = to_number(itemkey);
1047: END IF;
1048:

Line 1160: FROM oe_order_lines_all

1156: resultout := 'COMPLETE:Y';
1157: ELSE
1158: SELECT ato_line_id,shipped_quantity
1159: INTO l_ato_line_id,l_shipped_quantity
1160: FROM oe_order_lines_all
1161: WHERE line_id = to_number(itemkey);
1162:
1163: IF l_ato_line_id = to_number(itemkey) THEN
1164: -- Only ATO Models and ATO Items will have case

Line 1188: FROM OE_ORDER_LINES_ALL

1184: -- the activity with 'N'.
1185:
1186: SELECT ato_line_id
1187: INTO l_ato_line_id
1188: FROM OE_ORDER_LINES_ALL
1189: WHERE line_id = to_number(itemkey);
1190:
1191: IF l_ato_line_id = to_number(itemkey) THEN
1192:

Line 1281: FROM oe_order_lines_all

1277: -- Condition Removed for 2974151
1278:
1279: SELECT ato_line_id,item_type_code
1280: INTO l_ato_line_id,l_item_type_code
1281: FROM oe_order_lines_all
1282: WHERE line_id = to_number(itemkey);
1283:
1284: IF l_ato_line_id = to_number(itemkey) AND
1285: (l_item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

Line 1476: from oe_order_lines_all

1472: ELSIF (l_pur_release_status is null) THEN
1473: /* added for bug fix 5247444 */
1474: select source_type_code
1475: into l_source_type
1476: from oe_order_lines_all
1477: where line_id = to_number(itemkey);
1478: IF l_source_type = 'INTERNAL' THEN
1479: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||':'||wf_engine.eng_null; -- block workflow
1480: ELSE