APPS.CTO_WORKFLOW_API_PK dependencies on OE_DROP_SHIP_SOURCES

Line 598: from oe_drop_ship_sources

594:
595: Begin
596: select 'Y'
597: INTO l_req_created
598: from oe_drop_ship_sources
599: where line_id = p_order_line_id;
600: Exception
601: When others THEN
602: l_req_created := 'N';

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

805: begin
806: -- Fixed FP bug 4888964
807: -- For dropship orders, if the first time created PO is
808: -- cancelled and created another PO against the so req
809: -- OM will store two records in oe_drop_ship_sources table
810: -- till 11.5.10. Though, OM will store only one row from R12
811: -- if the data was created before R12, it can still have
812: -- more than one row for a given line id
813: -- We have chaged the sql to look at only non-cancelled po

Line 820: oe_drop_ship_sources ods

816: select poh.authorization_status
817: into v_authorization_status
818: from po_headers_all poh,
819: po_lines_all pol,
820: oe_drop_ship_sources ods
821: where ods.header_id = v_header_id
822: and ods.line_id = p_order_line_id
823: and ods.po_header_id = poh.po_header_id
824: and pol.po_line_id = ods.po_line_id