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.CTO_WORKFLOW_API_PK dependencies on OE_DROP_SHIP_SOURCES

Line 603: from oe_drop_ship_sources

599:
600: Begin
601: select 'Y'
602: INTO l_req_created
603: from oe_drop_ship_sources
604: where line_id = p_order_line_id;
605: Exception
606: When others THEN
607: l_req_created := 'N';

Line 818: -- OM will store two records in oe_drop_ship_sources table

814: begin
815: -- Fixed FP bug 4888964
816: -- For dropship orders, if the first time created PO is
817: -- cancelled and created another PO against the so req
818: -- OM will store two records in oe_drop_ship_sources table
819: -- till 11.5.10. Though, OM will store only one row from R12
820: -- if the data was created before R12, it can still have
821: -- more than one row for a given line id
822: -- We have chaged the sql to look at only non-cancelled po

Line 829: oe_drop_ship_sources ods

825: select poh.authorization_status
826: into v_authorization_status
827: from po_headers_all poh,
828: po_lines_all pol,
829: oe_drop_ship_sources ods
830: where ods.header_id = v_header_id
831: and ods.line_id = p_order_line_id
832: and ods.po_header_id = poh.po_header_id
833: and pol.po_line_id = ods.po_line_id