[go: up one dir, main page]
Scribd
Upload
76 views2 pages

Query For Hold Report

This document contains several SQL queries being run on various tables, including ap_holds_all, ap_invoices_all, PO_LINE_LOCATIONS_ALL, and PO_DISTRIBUTION_INTERFACE. The queries are selecting data and filtering based on project IDs and joining various tables to retrieve related data.

Uploaded by

Nikit Shah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
76 views2 pages

Query For Hold Report

This document contains several SQL queries being run on various tables, including ap_holds_all, ap_invoices_all, PO_LINE_LOCATIONS_ALL, and PO_DISTRIBUTION_INTERFACE. The queries are selecting data and filtering based on project IDs and joining various tables to retrieve related data.

Uploaded by

Nikit Shah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

--select * from ap_holds_all

--select * from PO_LINE_LOCATIONS_ALL

--select * from ap_invoices_all

--PO_LINES_ALL

select * from PO_DISTRIBUTIONS_INTERFACE

R3133

R3940

ARAJENDRAN3@MCDERMOTT.COM

Anbarasan Rajendran

select a.hold_reason, a.hold_date,b.invoice_num, a.held_by, c.quantity,


c.quantity_received, c.quantity_accepted,c.quantity_billed,d.Project

from ap_holds_all a, ap_invoices_all b, PO_LINE_LOCATIONS_ALL c,


PO_DISTRIBUTION_INTERFACE d

where a.line_location_id = c.line_location_id and a.line_location_id =


d.line_locaton_id and a.invoice_id = b.invoice_id

and d.project in(N0510,N0511)

and d.project in('N0510','N0511')

select a.hold_reason, a.hold_date,b.invoice_num, a.held_by, c.quantity,


c.quantity_received, c.quantity_accepted,c.quantity_billed,d.Project

from ap_holds_all a, ap_invoices_all b, PO_LINE_LOCATIONS_ALL c,


PO_DISTRIBUTIONS_INTERFACE d

where a.line_location_id = c.line_location_id and a.line_location_id =


d.line_location_id and a.invoice_id = b.invoice_id

64588,72937,75080,70632
and 64587

300000019048881

1194005

PJF_PROJECTS_BASIC_V

select a.hold_reason, a.hold_date,b.invoice_num, a.held_by, c.quantity,


c.quantity_received, c.quantity_accepted,c.quantity_billed,e.line_num,d.segment1

from ap_holds_all a, ap_invoices_all b, PO_LINE_LOCATIONS_ALL c, PO_HEADERS_ALL d,


PO_LINES_ALL e, PO_DISTRIBUTIONS_ALL f, PJF_PROJECTS_BASIC_V g

where a.line_location_id = c.line_location_id and a.invoice_id = b.invoice_id and


c.po_header_id = d.po_header_id and c.po_line_id = e.po_line_id and e.po_line_id =
f.po_line_id and f.pjc_project_id = g.project_id

You might also like