DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_LINES_ALL

Line 3100: FROM PO_LINES_ALL POL,PO_RELEASES_GT POR,PO_LINE_LOCATIONS_GT PLL

3096: l_shipment_num,
3097: l_dist_num,
3098: l_quantity1,
3099: l_quantity2
3100: FROM PO_LINES_ALL POL,PO_RELEASES_GT POR,PO_LINE_LOCATIONS_GT PLL
3101: WHERE PLL.po_release_id = POR.po_release_id
3102: AND PLL.po_release_id = p_document_id
3103: AND POL.po_line_id = PLL.po_line_id
3104: AND POL.min_release_amount is not null

Line 8871: FROM PO_LINES_GT POL, PO_HEADERS_GT POH, PO_HEADERS_ALL POH2, PO_LINES_ALL POL2, PO_LINE_LOCATIONS_GT PLL

8867: p_sequence + ROWNUM,
8868: substr(g_linemsg||g_delim||POL.line_num||g_delim
8869: ||l_textline,1,240),
8870: 'PO_SUB_STD_AFTER_GA_DATE'
8871: FROM PO_LINES_GT POL, PO_HEADERS_GT POH, PO_HEADERS_ALL POH2, PO_LINES_ALL POL2, PO_LINE_LOCATIONS_GT PLL
8872: WHERE POL.po_header_id = p_document_id
8873: AND POL.po_header_id = POH.po_header_id -- JOIN
8874: AND PLL.po_line_id = POL.po_line_id --JOIN, Bug #5415428 - Get the Need by date
8875: AND POL.from_header_id = POH2.po_header_id --JOIN

Line 9226: FROM PO_LINES_GT POL1, PO_LINES_ALL POL2, PO_HEADERS_ALL POH

9222: decode ( POL1.order_type_lookup_code --
9223: , 'FIXED PRICE' , 'PO_SUB_PO_LINE_GT_GA_AMT_TOL'
9224: , 'PO_SUB_PO_LINE_GT_GA_PRICE_TOL'
9225: )
9226: FROM PO_LINES_GT POL1, PO_LINES_ALL POL2, PO_HEADERS_ALL POH
9227: WHERE POL1.po_header_id = p_document_id
9228: AND POH.po_header_id = POL1.from_header_id --JOIN
9229: AND POH.type_lookup_code = 'BLANKET'
9230: AND POH.global_agreement_flag = 'Y'

Line 9298: FROM PO_LINES_GT POL1, PO_LINES_ALL POL2, PO_HEADERS_ALL POH

9294: p_sequence + ROWNUM,
9295: substr(g_linemsg||g_delim||POL1.line_num||g_delim
9296: ||l_textline,1,240),
9297: 'PO_SUB_STD_GA_LINE_LESS_MINREL' -- <2710030>
9298: FROM PO_LINES_GT POL1, PO_LINES_ALL POL2, PO_HEADERS_ALL POH
9299: WHERE POL1.po_header_id = p_document_id
9300: AND POL1.from_header_id = POL2.po_header_id --JOIN
9301: AND POL1.from_line_id = POL2.po_line_id --JOIN
9302: AND POL1.from_header_id = POH.po_header_id --JOIN

Line 9583: -- po_lines_gt) may not go to po_lines_all eventually

9579: -- total amount released for that contract on this PO
9580: -- SQL Why: Need to calculate the total amount released for the
9581: -- contract and we are calculating current PO and other
9582: -- POs separately because current PO lines (stored in
9583: -- po_lines_gt) may not go to po_lines_all eventually
9584: --: changed query to use Line qty/amt/price
9585: --instead of summing up the Line Loc values. The results should be
9586: --equivalent for SPOs.
9587:

Line 9639: po_lines_all POL1, -- all lines from other doc with

9635: , POL1.quantity * POL1.unit_price)*NVL(POH1.rate,1))
9636: BULK COLLECT INTO l_prev_doc_line_num,
9637: l_prev_rel_amount
9638: FROM po_lines_gt POL, -- target line
9639: po_lines_all POL1, -- all lines from other doc with
9640: -- the same GC ref
9641: po_headers_all POH1, -- headers of lines in POL1
9642: po_headers_all POHA -- global contract
9643: WHERE

Line 10765: , po_lines_all pol --

10761: -- Note: the value basis decode assumes Milestone Pay Items are Amount
10762: -- Milestones, since payment type is not changeable on Qty-based lines
10763: --
10764: FROM po_line_locations poll
10765: , po_lines_all pol --
10766: WHERE poll.line_location_id =
10767: p_requested_changes.shipment_changes.parent_line_location_id(i)
10768: AND p_requested_changes.shipment_changes.po_line_location_id(i) IS NULL
10769: AND poll.po_line_id = pol.po_line_id; --

Line 11486: FROM po_lines_all pol

11482: AMOUNT , --
11483: ORDER_TYPE_LOOKUP_CODE , --
11484: PURCHASE_BASIS , --
11485: MATCHING_BASIS --
11486: FROM po_lines_all pol
11487: WHERE pol.po_line_id = l_line_id_tbl(i)
11488: ;
11489:
11490: l_progress := '030';

Line 12773: OR EXISTS (SELECT null from po_lines_all l

12769: AND (h.closed_code is NULL or h.closed_code NOT IN ('FINALLY CLOSED'))
12770: AND (h.frozen_flag is NULL or h.frozen_flag <> 'Y')))
12771: AND (p_line_id(i) IS NULL
12772: --Case 3: Optionally, Line is specified
12773: OR EXISTS (SELECT null from po_lines_all l
12774: WHERE l.po_line_id = p_line_id(i)
12775: AND (l.cancel_flag is null or l.cancel_flag <> 'Y')
12776: AND (l.closed_code is NULL or l.closed_code NOT IN ('FINALLY CLOSED'))))
12777: AND (p_line_location_id(i) IS NULL

Line 13002: OR EXISTS (SELECT null from po_lines_all l

12998: AND (h.hold_flag is NULL or h.hold_flag <> 'Y')))
12999: AND (p_line_id(i) IS NULL
13000: --Case 3: Optionally, Line is specified
13001: -- Bug 3407980: Modified closed_code condition so that it only discards 'FINALLY CLOSED'
13002: OR EXISTS (SELECT null from po_lines_all l
13003: WHERE l.po_line_id = p_line_id(i)
13004: AND (l.closed_code is NULL or l.closed_code <> 'FINALLY CLOSED')))
13005: AND (p_line_location_id(i) IS NULL
13006: --Case 4: Optionally, Line Location is specified

Line 13171: OR EXISTS (SELECT null from po_lines_all l

13167: AND (h.hold_flag is NULL or h.hold_flag <> 'Y')))
13168: AND (p_line_id(i) IS NULL
13169: --Case 3: Optionally, Line is specified
13170: -- Bug 3407980: Modified closed_code condition so that it only discards 'FINALLY CLOSED'
13171: OR EXISTS (SELECT null from po_lines_all l
13172: WHERE l.po_line_id = p_line_id(i)
13173: AND (l.closed_code is NULL or l.closed_code <> 'FINALLY CLOSED')))
13174: AND (p_line_location_id(i) IS NULL
13175: --Case 4: Optionally, Line Location is specified

Line 13342: FROM po_lines_all s

13338: UPDATE po_headers_gt gt
13339: SET (closed_code, cancel_flag, user_hold_flag)
13340: =
13341: (SELECT nvl(closed_code, 'OPEN'), NVL(cancel_flag, 'N'), NVL(user_hold_flag, 'N')
13342: FROM po_lines_all s
13343: WHERE s.po_line_id = p_line_id(i))
13344: WHERE p_line_id(i) is not null and gt.po_header_id = l_sequence(i)
13345: ;
13346:

Line 13736: , PO_LINES_ALL POL -- For releases, PO_LINES_GT table isn't populated.

13732: , 'PO_SUB_SHIP_BILL_GT_ORD_QTY'
13733: )
13734: FROM
13735: PO_LINE_LOCATIONS_GT POLL
13736: , PO_LINES_ALL POL -- For releases, PO_LINES_GT table isn't populated.
13737: WHERE POLL.po_line_id = POL.po_line_id
13738: AND nvl(POLL.cancel_flag, 'N') = 'N'
13739: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'
13740: AND ( --

Line 13825: , PO_LINES_ALL POL -- For releases, PO_LINES_GT table isn't populated.

13821: )
13822: FROM
13823: PO_DISTRIBUTIONS_GT POD
13824: , PO_LINE_LOCATIONS_GT POLL
13825: , PO_LINES_ALL POL -- For releases, PO_LINES_GT table isn't populated.
13826: WHERE POD.line_location_id = POLL.line_location_id
13827: AND POL.po_line_id = POLL.po_line_id
13828: AND nvl(POLL.cancel_flag, 'N') = 'N'
13829: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 13913: , PO_LINES_ALL POL -- For releases, PO_LINES_GT table isn't populated.

13909: )
13910: FROM
13911: PO_DISTRIBUTIONS_GT POD
13912: , PO_LINE_LOCATIONS_GT POLL
13913: , PO_LINES_ALL POL -- For releases, PO_LINES_GT table isn't populated.
13914: WHERE POD.line_location_id = POLL.line_location_id
13915: AND POL.po_line_id = POLL.po_line_id
13916: AND nvl(POLL.cancel_flag,'N') = 'N'
13917: AND nvl(POLL.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 14815: , PO_LINES_ALL POL -- For Releases, PO_LINES_GT doesn't get populated.

14811: , l_distribution_num_tbl
14812: FROM
14813: PO_DISTRIBUTIONS_GT POD
14814: , PO_LINE_LOCATIONS_GT POLL
14815: , PO_LINES_ALL POL -- For Releases, PO_LINES_GT doesn't get populated.
14816: , PO_HEADERS_GT POH
14817: WHERE POLL.line_location_id(+) = POD.line_location_id --JOIN
14818: AND POL.po_line_id(+) = POD.po_line_id --JOIN
14819: -- PA distributions don't have associated lines or shipments

Line 16545: FROM po_lines_all pol2

16541: FROM po_lines_gt pol
16542: WHERE EXISTS
16543: (
16544: SELECT 'Uncancelled Std PO lines referencing this GA line exist'
16545: FROM po_lines_all pol2
16546: WHERE pol2.from_line_id = pol.po_line_id
16547: AND NVL(pol2.cancel_flag, 'N') = 'N'
16548: AND NVL(pol2.closed_code, 'OPEN') <> 'FINALLY CLOSED'
16549: );

Line 16641: FROM po_lines_all pol

16637: FROM po_headers_gt poh
16638: WHERE EXISTS
16639: (
16640: SELECT 'Open Std PO lines referencing this contract exist'
16641: FROM po_lines_all pol
16642: WHERE pol.contract_id = poh.po_header_id
16643: AND NVL(pol.cancel_flag, 'N') = 'N'
16644: AND NVL(pol.closed_code, 'OPEN') <> 'FINALLY CLOSED'
16645: );

Line 17782: po_lines_all pol,

17778: l_ship_to_organization_id,
17779: l_consigned_flag,
17780: l_outsourced_assembly
17781: FROM po_line_locations_all poll,
17782: po_lines_all pol,
17783: po_headers_all poh
17784: WHERE poh.po_header_id = pol.po_header_id
17785: AND pol.po_line_id = poll.po_line_id
17786: AND poll.line_location_id = p_line_location_id;