eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_RELEASES

Line 3000: FROM PO_RELEASES_ALL

2996: -- retrieve the vendor and vendor site id
2997: BEGIN
2998: SELECT po_header_id
2999: INTO l_po_header_id
3000: FROM PO_RELEASES_ALL
3001: WHERE po_release_id = l_document_id;
3002: EXCEPTION
3003: WHEN OTHERS THEN
3004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4138: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH

4134: 0,0,0,
4135: p_sequence + ROWNUM,
4136: substr(l_textline,1,240),
4137: 'PO_SUB_REL_PA_APPROVED'
4138: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH
4139: WHERE POR.po_header_id = POH.po_header_id
4140: AND POR.po_release_id = p_document_id
4141: AND NVL(POH.approved_flag, 'N') <> 'Y'
4142: AND NVL(POH.user_hold_flag, 'N') <> 'Y'; --< Bug 3422733 >

Line 4197: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH

4193: 0,
4194: p_sequence + ROWNUM,
4195: substr(l_textline,1,240),
4196: 'PO_SUB_REL_PA_EXPIRED' -- bug3199869
4197: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH
4198: WHERE POR.po_header_id = POH.po_header_id
4199: AND POR.po_release_id = p_document_id
4200: AND POR.approved_date IS NULL -- bug3199869
4201: AND TRUNC(SYSDATE) > -- bug3199869

Line 4245: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH

4241: 0,
4242: p_sequence + ROWNUM,
4243: substr(l_textline,1,240),
4244: 'PO_SUB_REL_PA_ON_HOLD'
4245: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH
4246: WHERE POR.po_header_id = POH.po_header_id
4247: AND POR.po_release_id = p_document_id
4248: AND nvl(POH.user_hold_flag, 'N') = 'Y';
4249:

Line 4291: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH,PO_VENDORS POV,

4287: 0,
4288: p_sequence + ROWNUM,
4289: substr(l_textline,1,240),
4290: 'PO_SUB_REL_VENDOR_ON_HOLD'
4291: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH,PO_VENDORS POV,
4292: PO_SYSTEM_PARAMETERS PSP
4293: WHERE POR.po_header_id = POH.po_header_id
4294: AND POV.vendor_id = POH.vendor_id
4295: AND POR.po_release_id = p_document_id

Line 4340: FROM PO_RELEASES_GT POR

4336: 0,
4337: p_sequence + ROWNUM,
4338: substr(l_textline,1,240),
4339: 'PO_SUB_REL_NO_SHIP'
4340: FROM PO_RELEASES_GT POR
4341: WHERE POR.po_release_id = p_document_id
4342: AND NOT EXISTS
4343: (SELECT 'Shipment Exist'
4344: FROM PO_LINE_LOCATIONS_GT PLL

Line 4699: PO_RELEASES_GT POR,PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,

4695: ||l_textline,1,240),
4696: 'PO_SUB_REL_RATE_NULL'
4697: FROM PO_DISTRIBUTIONS_GT POD, --
4698: PO_LINE_LOCATIONS_GT POLL,PO_LINES POL,
4699: PO_RELEASES_GT POR,PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,
4700: FINANCIALS_SYSTEM_PARAMETERS FSP
4701: WHERE POLL.po_release_id = POR.po_release_id
4702: AND POD.line_location_id = POLL.line_location_id
4703: AND POLL.po_line_id = POL.po_line_id

Line 4754: FROM PO_HEADERS_GT POH,PO_RELEASES_GT POR

4750: 0,
4751: p_sequence + ROWNUM,
4752: substr(l_textline,1,240),
4753: 'PO_SUB_REL_AMT_LESS_MINREL_AMT'
4754: FROM PO_HEADERS_GT POH,PO_RELEASES_GT POR
4755: WHERE POR.po_release_id = p_document_id
4756: AND POH.po_header_id = POR.po_header_id
4757: AND POH.min_release_amount IS NOT NULL
4758: AND POH.min_release_amount > --

Line 4811: FROM PO_LINE_LOCATIONS_GT PLL1, PO_RELEASES_GT POR1, PO_HEADERS_GT POH

4807: , ( ( PLL1.quantity
4808: - nvl(PLL1.quantity_cancelled,0) )
4809: * PLL1.price_override ) ) )
4810: INTO l_this_rel_amount
4811: FROM PO_LINE_LOCATIONS_GT PLL1, PO_RELEASES_GT POR1, PO_HEADERS_GT POH
4812: WHERE POR1.po_release_id = p_document_id
4813: AND POR1.po_header_id = POH.po_header_id -- Bug 7188760
4814: AND POH.amount_limit is Not Null -- Bug 7188760
4815: AND PLL1.po_release_id = POR1.po_release_id;

Line 4836: FROM PO_LINE_LOCATIONS PLL2, PO_RELEASES POR2, PO_HEADERS_GT POH

4832: - nvl(PLL2.quantity_cancelled,0) )
4833: * PLL2.price_override ) ) )
4834: , 0 )
4835: INTO l_previous_rel_amount
4836: FROM PO_LINE_LOCATIONS PLL2, PO_RELEASES POR2, PO_HEADERS_GT POH
4837: WHERE PLL2.po_release_id = POR2.po_release_id
4838: AND POR2.po_header_id = POH.po_header_id
4839: AND nvl(POR2.approved_flag, 'N') = 'Y'
4840: AND POH.amount_limit is Not Null -- Bug 7188760

Line 4857: FROM po_line_locations_archive_all PLL2, po_releases_all POR2, PO_HEADERS_GT POH

4853: - nvl(PLL2.quantity_cancelled,0) )
4854: * PLL2.price_override ) ) )
4855: , 0 )
4856: INTO l_previous_rel_archive_amount
4857: FROM po_line_locations_archive_all PLL2, po_releases_all POR2, PO_HEADERS_GT POH
4858: WHERE PLL2.po_release_id = POR2.po_release_id
4859: AND POR2.po_header_id = POH.po_header_id
4860: AND nvl(POR2.approved_flag, 'N') IN ('R','F')
4861: and NVL(PLL2.LATEST_EXTERNAL_FLAG,'N') = 'Y'

Line 4897: FROM PO_HEADERS_GT POH,PO_RELEASES_GT POR

4893: 0,
4894: p_sequence + ROWNUM,
4895: substr(l_textline,1,240),
4896: 'PO_SUB_REL_AMT_GRT_LIMIT_AMT'
4897: FROM PO_HEADERS_GT POH,PO_RELEASES_GT POR
4898: WHERE POR.po_release_id = p_document_id
4899: AND POH.po_header_id = POR.po_header_id
4900:
4901: AND POH.amount_limit is not null

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

4933: l_shipment_num,
4934: l_dist_num,
4935: l_quantity1,
4936: l_quantity2
4937: FROM PO_LINES_ALL POL,PO_RELEASES_GT POR,PO_LINE_LOCATIONS_GT PLL
4938: WHERE PLL.po_release_id = POR.po_release_id
4939: AND PLL.po_release_id = p_document_id
4940: AND POL.po_line_id = PLL.po_line_id
4941: AND POL.min_release_amount is not null

Line 5146: PO_RELEASES_GT POR,PO_LINES POL, PO_HEADERS_GT POH,

5142: ||l_textline,1,240),
5143: --
5144: 'PO_SUB_ITEM_NOT_APPROVED_REL'
5145: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS_GT PLL,
5146: PO_RELEASES_GT POR,PO_LINES POL, PO_HEADERS_GT POH,
5147: FINANCIALS_SYSTEM_PARAMETERS FSP
5148: WHERE POR.po_release_id = p_document_id
5149: AND POR.po_header_id = POH.po_header_id
5150: AND POR.po_header_id = POL.po_header_id

Line 5248: PO_RELEASES_GT POR,PO_LINES POL, PO_HEADERS_GT POH,

5244: ||l_textline,1,240),
5245: --
5246: 'PO_SUB_ITEM_ASL_DEBARRED_REL'
5247: FROM PO_LINE_LOCATIONS_GT PLL,
5248: PO_RELEASES_GT POR,PO_LINES POL, PO_HEADERS_GT POH,
5249: FINANCIALS_SYSTEM_PARAMETERS FSP
5250: WHERE POR.po_release_id = p_document_id
5251: AND POR.po_header_id = POH.po_header_id
5252: AND POR.po_header_id = POL.po_header_id

Line 5385: from po_releases_gt por,po_lines pl,po_line_locations_gt pll,mtl_system_items itm,po_line_types_b plt

5381: 0,
5382: p_sequence + ROWNUM,
5383: substr(g_shipmsg||g_delim||pll.shipment_num||g_delim||l_textline,1,240),
5384: 'PO_ALL_NO_ITEM'
5385: from po_releases_gt por,po_lines pl,po_line_locations_gt pll,mtl_system_items itm,po_line_types_b plt
5386: where itm.inventory_item_id = pl.item_id
5387: and pl.item_id is not null
5388:
5389: and pl.po_line_id = pll.po_line_id

Line 5438: FROM PO_RELEASES_GT POR

5434: 0,
5435: p_sequence + ROWNUM,
5436: substr(l_textline,1,240),
5437: 'PO_ON_HOLD_CANNOT_APPROVE'
5438: FROM PO_RELEASES_GT POR
5439: WHERE POR.po_release_id = p_document_id
5440: AND nvl(POR.HOLD_FLAG,'N') = 'Y';
5441:
5442: --Increment the p_sequence with number of errors reported in last query

Line 5451: from po_headers_gt poh, po_releases_gt por

5447: ---------------------------------------------------------------------------------
5448: -- bug 6530879 Releases
5449: select poh.po_header_id,poh.vendor_id, poh.vendor_site_id, poh.vendor_contact_id
5450: into l_agreement_id, l_vendor_id,l_vendor_site_id,l_vendor_contact_id
5451: from po_headers_gt poh, po_releases_gt por
5452: where poh.po_header_id = por.po_header_id
5453: and por.po_release_id = p_document_id;
5454: -- bug 6530879
5455: -- Check 20: Vendor should be valid when approving the document.

Line 5758: FROM PO_RELEASES_GT POR,

5754: 0,
5755: p_sequence + ROWNUM,
5756: substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||l_textline,1,240),
5757: 'PO_SUB_REL_SHIP_INV_MATCH_NE_R'
5758: FROM PO_RELEASES_GT POR,
5759: PO_LINE_LOCATIONS_GT PLL
5760: WHERE POR.po_release_id = PLL.po_release_id
5761: AND POR.po_release_id = p_document_id
5762: AND Nvl(PLL.LCM_FLAG,'N') = 'Y'

Line 5804: FROM PO_RELEASES_GT POR,

5800: p_sequence + ROWNUM,
5801: substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||g_distmsg||g_delim||
5802: POD.distribution_num||g_delim||l_textline, 1,240),
5803: 'PO_SUB_REL_DIST_DEST_TYPE_NE_I'
5804: FROM PO_RELEASES_GT POR,
5805: PO_LINE_LOCATIONS_GT PLL,
5806: PO_DISTRIBUTIONS_GT POD
5807: WHERE POR.po_release_id = POD.po_release_id
5808: AND POD.line_location_id = PLL.line_location_id

Line 5853: from PO_RELEASES_GT POR,

5849: l_textline,
5850: 'PO_BUYER_INACTIVE'
5851: FROM dual
5852: where not exists (select 'inactive buyer'
5853: from PO_RELEASES_GT POR,
5854: PO_BUYERS_V POB -- Replace PO_BUYERS_VAL_V with PO_BUYERS_V
5855: where por.agent_id = pob.employee_id);
5856:
5857:

Line 13488: DELETE FROM po_releases_gt;

13484: DELETE FROM po_headers_gt;
13485: DELETE FROM po_lines_gt;
13486: DELETE FROM po_line_locations_gt;
13487: DELETE FROM po_distributions_gt;
13488: DELETE FROM po_releases_gt;
13489: DELETE FROM po_req_headers_gt;
13490: DELETE FROM po_req_lines_gt;
13491: DELETE FROM po_req_distributions_gt;
13492: DELETE FROM po_online_report_text_gt;

Line 13589: FROM po_releases_gt

13585: l_progress := '009';
13586: -- Get the header_id of the relevent Blanket
13587: SELECT po_header_id
13588: INTO l_blanket_header_id
13589: FROM po_releases_gt
13590: WHERE po_release_id = l_doc_id;
13591:
13592: l_progress := '010';
13593: --populate the global headers table with header of blanket/planned PO

Line 15056: || l_progress,'Populate PO Releases');

15052: l_progress := '000';
15053: IF g_debug_stmt THEN
15054: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
15055: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
15056: || l_progress,'Populate PO Releases');
15057: END IF;
15058: END IF;
15059:
15060: INSERT INTO po_releases_gt(

Line 15060: INSERT INTO po_releases_gt(

15056: || l_progress,'Populate PO Releases');
15057: END IF;
15058: END IF;
15059:
15060: INSERT INTO po_releases_gt(
15061: PO_RELEASE_ID ,
15062: LAST_UPDATE_DATE ,
15063: LAST_UPDATED_BY ,
15064: PO_HEADER_ID ,

Line 15234: FROM po_releases

15230: XML_SEND_DATE ,
15231: XML_CHANGE_SEND_DATE ,
15232: CONSIGNED_CONSUMPTION_FLAG ,
15233: CBC_ACCOUNTING_DATE
15234: FROM po_releases
15235: WHERE po_release_id = p_document_id;
15236:
15237: l_progress := '001';
15238: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 16283: OR EXISTS (select null from po_releases_all h

16279: AND (h.closed_code is NULL or h.closed_code NOT IN ('FINALLY CLOSED'))
16280: AND (h.frozen_flag is NULL or h.frozen_flag <> 'Y')))
16281: AND (p_release_id(i) IS NULL
16282: --Case 2: PO Release is specified
16283: OR EXISTS (select null from po_releases_all h
16284: WHERE h.po_release_id = p_release_id(i)
16285: AND (h.authorization_status is NULL
16286: OR h.authorization_status NOT IN ('PRE-APPROVED', 'IN PROCESS'))
16287: AND (h.cancel_flag is null or h.cancel_flag <> 'Y')

Line 16516: OR EXISTS (select null from po_releases_all h

16512: AND (h.user_hold_flag is NULL or h.user_hold_flag <> 'Y')))
16513: AND (p_release_id(i) IS NULL
16514: --Case 2: PO Release is specified
16515: -- Bug 3407980: Modified closed_code condition so that it only discards 'FINALLY CLOSED'
16516: OR EXISTS (select null from po_releases_all h
16517: WHERE h.po_release_id = p_release_id(i)
16518: AND (h.authorization_status is NULL
16519: OR h.authorization_status NOT IN ('APPROVED'))
16520: AND (h.closed_code is NULL or h.closed_code <> 'FINALLY CLOSED')

Line 16687: OR EXISTS (select null from po_releases_all h

16683: AND (h.user_hold_flag is NULL or h.user_hold_flag <> 'Y')))
16684: AND (p_release_id(i) IS NULL
16685: --Case 2: PO Release is specified
16686: -- Bug 3407980: Modified closed_code condition so that it only discards 'FINALLY CLOSED'
16687: OR EXISTS (select null from po_releases_all h
16688: WHERE h.po_release_id = p_release_id(i)
16689: AND (h.closed_code is NULL or h.closed_code <> 'FINALLY CLOSED')
16690: AND (h.frozen_flag is NULL or h.frozen_flag <> 'Y')
16691: AND (h.hold_flag is NULL or h.hold_flag <> 'Y')))

Line 16855: FROM po_releases_all h

16851: ' ' dummy, ' ' dummy, ' ' dummy,
16852: NVL(authorization_status, 'INCOMPLETE'), nvl(approved_flag, 'N'),
16853: nvl(closed_code, 'OPEN'), NVL(cancel_flag, 'N'),
16854: NVL(frozen_flag, 'N'), NVL(hold_flag, 'N'), l_sequence(i)
16855: FROM po_releases_all h
16856: WHERE h.po_release_id = p_release_id(i)
16857: ;
16858:
16859: --IF line ID present at an index, overwrite the status fields with Line Level status

Line 19329: FROM po_releases_gt por

19325: , 0
19326: , p_sequence + ROWNUM
19327: , substr(l_textline, 1, 240)
19328: , 'PO_CAN_REL_WITH_RCV_TRX'
19329: FROM po_releases_gt por
19330: WHERE EXISTS
19331: (
19332: SELECT 'Eligible shipment'
19333: FROM po_line_locations_gt poll

Line 19507: FROM po_releases_gt por

19503: FROM po_line_locations_gt poll
19504: WHERE EXISTS
19505: (
19506: SELECT 'Eligible shipment'
19507: FROM po_releases_gt por
19508: WHERE por.po_release_id = poll.po_release_id
19509: AND NVL(por.cancel_flag, 'N') = 'N'
19510: AND NVL(por.closed_code, 'OPEN') <> 'FINALLY CLOSED'
19511: )

Line 19700: FROM po_releases_gt por, po_line_locations_gt poll

19696: , 0
19697: , p_sequence + ROWNUM
19698: , substr(g_shipmsg || g_delim || poll.shipment_num || g_delim || l_textline, 1, 240)
19699: , 'PO_CAN_POLL_WITH_ASN'
19700: FROM po_releases_gt por, po_line_locations_gt poll
19701: WHERE poll.po_release_id = por.po_release_id
19702: AND NVL(poll.cancel_flag, 'N') = 'N'
19703: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
19704: AND EXISTS

Line 19875: FROM po_releases_gt por

19871: FROM po_line_locations_gt poll
19872: WHERE EXISTS
19873: (
19874: SELECT 'Eligible shipment'
19875: FROM po_releases_gt por
19876: WHERE por.po_release_id = poll.po_release_id
19877: AND NVL(por.cancel_flag, 'N') = 'N'
19878: AND NVL(por.closed_code, 'OPEN') <> 'FINALLY CLOSED'
19879: )

Line 21506: FROM po_releases_gt por

21502: , null -- distribution_num
21503: , p_sequence + ROWNUM
21504: , substr(l_textline, 1, 240)
21505: , l_message_name
21506: FROM po_releases_gt por
21507: WHERE por.po_release_id=p_doc_level_id
21508: AND chk_unv_invoices(l_invoice_type, por.po_header_id, por.po_release_id, NULL,NULL, NULL, p_origin_doc_id, l_calling_sequence) = 1;
21509:
21510: --

Line 23496: po_releases_gt pr

23492: 'PO_CLOSE_WIP_JOB'
23493: FROM po_headers_gt ph,
23494: po_line_locations_gt pll,
23495: po_distributions_gt pd,
23496: po_releases_gt pr
23497: WHERE 1=1
23498: AND ph.po_header_id = pll.po_header_id
23499: AND pll.line_location_id = pd.line_location_id
23500: AND pr.po_release_id (+) = pd.po_release_id

Line 26375: PO_RELEASES_GT POR

26371: FROM
26372: PO_DISTRIBUTIONS_GT POD,
26373: PO_LINE_LOCATIONS_GT POLL,
26374: PO_LINES POL,
26375: PO_RELEASES_GT POR
26376:
26377: WHERE
26378: POR.po_release_id = P_DOCUMENT_ID
26379: AND POR.po_header_id = POL.po_header_id