APPS.WMS_RULES_WORKBENCH_PVT dependencies on STANDARD

Line 1806: and pll.shipment_type = 'STANDARD'

1802: po_line_locations_all pll
1803: where poh.po_header_id = pol.po_header_id
1804: and pll.po_header_id = pol.po_header_id
1805: and pll.po_line_id = pol.po_line_id
1806: and pll.shipment_type = 'STANDARD'
1807: and pll.line_location_id = p_reference_id ;
1808:
1809: elsif (p_reference = 'PO_DISTRIBUTION_ID' ) then
1810: select poh.vendor_id into l_vendor_id

Line 1821: and pll.shipment_type = 'STANDARD'

1817: and pll.po_line_id = pol.po_line_id
1818: and pod.po_header_id = pll.po_header_id
1819: and pod.po_line_id = pll.po_line_id
1820: and pod.line_location_id = pll.line_location_id
1821: and pll.shipment_type = 'STANDARD'
1822: and pod.po_distribution_id = p_reference_id;
1823: Else
1824: select poh.vendor_id into l_vendor_id
1825: from po_headers_all poh,

Line 1835: and pll.shipment_type = 'STANDARD'

1831: and pll.po_line_id = pol.po_line_id
1832: and rct.po_header_id = pll.po_header_id
1833: and rct.po_line_id = pll.po_line_id
1834: and rct.po_line_location_id = pll.line_location_id
1835: and pll.shipment_type = 'STANDARD'
1836: and rct.transaction_id = p_reference_id;
1837: End if;
1838: Return l_vendor_id;
1839: Exception