SELECT DISTINCT pv.vendor_name
FROM po.po_requisition_headers_all prha
, po.po_requisition_lines_all prla
, po_req_distributions_all prd
, applsys.fnd_user fu
, wip.wip_entities we
, po_headers_all poh
, po_lines_all pol
, po_line_locations_all pll
, po_distributions_all pod
, po_vendors pv
WHERE prha.requisition_header_id = prla.requisition_header_id
AND prha.created_by = fu.user_id
AND prla.wip_entity_id = :WIP_ENTITY_ID
AND prha.creation_date > '25-JUL-2013'
AND prd.requisition_line_id = prla.requisition_line_id
AND prd.distribution_id = pod.req_distribution_id
AND pod.po_header_id = pll.po_header_id
AND pod.po_line_id = pll.po_line_id
AND pod.line_location_id = pll.line_location_id
AND pll.po_line_id = pol.po_line_id
AND pll.po_header_id = pll.po_header_id
AND pol.po_header_id = poh.po_header_id
AND poh.vendor_id = pv.vendor_id;
SELECT DISTINCT poh.segment1 into V_PO
FROM po.po_requisition_headers_all prha
, po.po_requisition_lines_all prla
, po_req_distributions_all prd
, applsys.fnd_user fu
, wip.wip_entities we
, po_headers_all poh
, po_lines_all pol
, po_line_locations_all pll
, po_distributions_all pod
, po_vendors pv
WHERE prha.requisition_header_id = prla.requisition_header_id
AND prha.created_by = fu.user_id
AND prla.wip_entity_id = :WIP_ENTITY_ID
-- AND prha.creation_date > '25-JUL-2013'
AND prd.requisition_line_id = prla.requisition_line_id
AND prd.distribution_id = pod.req_distribution_id
AND pod.po_header_id = pll.po_header_id
AND pod.po_line_id = pll.po_line_id
AND pod.line_location_id = pll.line_location_id
AND pll.po_line_id = pol.po_line_id
AND pll.po_header_id = pll.po_header_id
AND pol.po_header_id = poh.po_header_id
AND poh.vendor_id = pv.vendor_id;
, po.po_requisition_lines_all prla
, po_req_distributions_all prd
, applsys.fnd_user fu
, wip.wip_entities we
, po_headers_all poh
, po_lines_all pol
, po_line_locations_all pll
, po_distributions_all pod
, po_vendors pv
WHERE prha.requisition_header_id = prla.requisition_header_id
AND prha.created_by = fu.user_id
AND prla.wip_entity_id = :WIP_ENTITY_ID
AND prha.creation_date > '25-JUL-2013'
AND prd.requisition_line_id = prla.requisition_line_id
AND prd.distribution_id = pod.req_distribution_id
AND pod.po_header_id = pll.po_header_id
AND pod.po_line_id = pll.po_line_id
AND pod.line_location_id = pll.line_location_id
AND pll.po_line_id = pol.po_line_id
AND pll.po_header_id = pll.po_header_id
AND pol.po_header_id = poh.po_header_id
AND poh.vendor_id = pv.vendor_id;
SELECT DISTINCT poh.segment1 into V_PO
FROM po.po_requisition_headers_all prha
, po.po_requisition_lines_all prla
, po_req_distributions_all prd
, applsys.fnd_user fu
, wip.wip_entities we
, po_headers_all poh
, po_lines_all pol
, po_line_locations_all pll
, po_distributions_all pod
, po_vendors pv
WHERE prha.requisition_header_id = prla.requisition_header_id
AND prha.created_by = fu.user_id
AND prla.wip_entity_id = :WIP_ENTITY_ID
-- AND prha.creation_date > '25-JUL-2013'
AND prd.requisition_line_id = prla.requisition_line_id
AND prd.distribution_id = pod.req_distribution_id
AND pod.po_header_id = pll.po_header_id
AND pod.po_line_id = pll.po_line_id
AND pod.line_location_id = pll.line_location_id
AND pll.po_line_id = pol.po_line_id
AND pll.po_header_id = pll.po_header_id
AND pol.po_header_id = poh.po_header_id
AND poh.vendor_id = pv.vendor_id;
center tables from Vibecrafts are perfect for completing your living room setup with simple and modern designs. Explore a variety of styles that fit different spaces and daily needs. Find good quality options at affordable prices and make your space more organized with Vibecrafts.
ReplyDeletecenter tables from Vibecrafts are designed to fit modern living spaces with ease. Built for everyday use, they offer the right mix of style and function. Explore options that help keep your living room organized while adding a neat and balanced look to your home.
ReplyDeletecenter tables from Vibecrafts are suitable for living rooms, apartments, and family spaces. These tables help maintain organized seating areas while supporting everyday utility and home decoration needs. Vibecrafts offers simple center tables designs that match different furniture setups and provide practical solutions for comfortable and balanced modern interiors.
ReplyDeletecenter tables at Vibecrafts, designed to complement modern and traditional living rooms. Our collection features wooden and contemporary designs that provide a practical surface for daily use while enhancing the overall look of your seating area with quality craftsmanship and thoughtful design.
ReplyDelete
ReplyDeletecenter tables at Vibecrafts designed for living rooms, lounges, and family spaces. Our collection offers practical furniture that pairs well with sofas and seating arrangements, helping organize your space while adding character and complementing both modern and traditional home interiors.
ReplyDeletecenter tables at Vibecrafts designed for living rooms, lounges, and family spaces. Our collection offers practical furniture for displaying decor, serving guests, and organizing everyday essentials while complementing both modern and traditional interiors with attractive designs and lasting functionality.