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 1214: FROM PO_RELEASES_ALL

1210: -- retrieve the vendor and vendor site id
1211: BEGIN
1212: SELECT po_header_id
1213: INTO l_po_header_id
1214: FROM PO_RELEASES_ALL
1215: WHERE po_release_id = l_document_id;
1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2336: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH

2332: 0,0,0,
2333: p_sequence + ROWNUM,
2334: substr(l_textline,1,240),
2335: 'PO_SUB_REL_PA_APPROVED'
2336: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH
2337: WHERE POR.po_header_id = POH.po_header_id
2338: AND POR.po_release_id = p_document_id
2339: AND NVL(POH.approved_flag, 'N') <> 'Y'
2340: AND NVL(POH.user_hold_flag, 'N') <> 'Y'; --< Bug 3422733 >

Line 2389: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH

2385: 0,
2386: p_sequence + ROWNUM,
2387: substr(l_textline,1,240),
2388: 'PO_SUB_REL_PA_EXPIRED' -- bug3199869
2389: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH
2390: WHERE POR.po_header_id = POH.po_header_id
2391: AND POR.po_release_id = p_document_id
2392: AND POR.approved_date IS NULL -- bug3199869
2393: AND TRUNC(SYSDATE) > -- bug3199869

Line 2437: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH

2433: 0,
2434: p_sequence + ROWNUM,
2435: substr(l_textline,1,240),
2436: 'PO_SUB_REL_PA_ON_HOLD'
2437: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH
2438: WHERE POR.po_header_id = POH.po_header_id
2439: AND POR.po_release_id = p_document_id
2440: AND nvl(POH.user_hold_flag, 'N') = 'Y';
2441:

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

2479: 0,
2480: p_sequence + ROWNUM,
2481: substr(l_textline,1,240),
2482: 'PO_SUB_REL_VENDOR_ON_HOLD'
2483: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH,PO_VENDORS POV,
2484: PO_SYSTEM_PARAMETERS PSP
2485: WHERE POR.po_header_id = POH.po_header_id
2486: AND POV.vendor_id = POH.vendor_id
2487: AND POR.po_release_id = p_document_id

Line 2532: FROM PO_RELEASES_GT POR

2528: 0,
2529: p_sequence + ROWNUM,
2530: substr(l_textline,1,240),
2531: 'PO_SUB_REL_NO_SHIP'
2532: FROM PO_RELEASES_GT POR
2533: WHERE POR.po_release_id = p_document_id
2534: AND NOT EXISTS
2535: (SELECT 'Shipment Exist'
2536: FROM PO_LINE_LOCATIONS_GT PLL

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

2887: ||l_textline,1,240),
2888: 'PO_SUB_REL_RATE_NULL'
2889: FROM PO_DISTRIBUTIONS_GT POD, --
2890: PO_LINE_LOCATIONS_GT POLL,PO_LINES POL,
2891: PO_RELEASES_GT POR,PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,
2892: FINANCIALS_SYSTEM_PARAMETERS FSP
2893: WHERE POLL.po_release_id = POR.po_release_id
2894: AND POD.line_location_id = POLL.line_location_id
2895: AND POLL.po_line_id = POL.po_line_id

Line 2946: FROM PO_HEADERS_GT POH,PO_RELEASES_GT POR

2942: 0,
2943: p_sequence + ROWNUM,
2944: substr(l_textline,1,240),
2945: 'PO_SUB_REL_AMT_LESS_MINREL_AMT'
2946: FROM PO_HEADERS_GT POH,PO_RELEASES_GT POR
2947: WHERE POR.po_release_id = p_document_id
2948: AND POH.po_header_id = POR.po_header_id
2949: AND POH.min_release_amount IS NOT NULL
2950: AND POH.min_release_amount > --

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

2999: , ( ( PLL1.quantity
3000: - nvl(PLL1.quantity_cancelled,0) )
3001: * PLL1.price_override ) ) )
3002: INTO l_this_rel_amount
3003: FROM PO_LINE_LOCATIONS_GT PLL1, PO_RELEASES_GT POR1, PO_HEADERS_GT POH
3004: WHERE POR1.po_release_id = p_document_id
3005: AND POR1.po_header_id = POH.po_header_id -- Bug 7188760
3006: AND POH.amount_limit is Not Null -- Bug 7188760
3007: AND PLL1.po_release_id = POR1.po_release_id;

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

3018: - nvl(PLL2.quantity_cancelled,0) )
3019: * PLL2.price_override ) ) )
3020: , 0 )
3021: INTO l_previous_rel_amount
3022: FROM PO_LINE_LOCATIONS PLL2, PO_RELEASES POR2, PO_HEADERS_GT POH
3023: WHERE PLL2.po_release_id = POR2.po_release_id
3024: AND POR2.po_header_id = POH.po_header_id
3025: AND nvl(POR2.approved_flag, 'N') = 'Y'
3026: AND POH.amount_limit is Not Null -- Bug 7188760

Line 3060: FROM PO_HEADERS_GT POH,PO_RELEASES_GT POR

3056: 0,
3057: p_sequence + ROWNUM,
3058: substr(l_textline,1,240),
3059: 'PO_SUB_REL_AMT_GRT_LIMIT_AMT'
3060: FROM PO_HEADERS_GT POH,PO_RELEASES_GT POR
3061: WHERE POR.po_release_id = p_document_id
3062: AND POH.po_header_id = POR.po_header_id
3063:
3064: AND POH.amount_limit is not null

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 3309: PO_RELEASES_GT POR,PO_LINES POL, PO_HEADERS_GT POH,

3305: ||l_textline,1,240),
3306: --
3307: 'PO_SUB_ITEM_NOT_APPROVED_REL'
3308: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS_GT PLL,
3309: PO_RELEASES_GT POR,PO_LINES POL, PO_HEADERS_GT POH,
3310: FINANCIALS_SYSTEM_PARAMETERS FSP
3311: WHERE POR.po_release_id = p_document_id
3312: AND POR.po_header_id = POH.po_header_id
3313: AND POR.po_header_id = POL.po_header_id

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

3407: ||l_textline,1,240),
3408: --
3409: 'PO_SUB_ITEM_ASL_DEBARRED_REL'
3410: FROM PO_LINE_LOCATIONS_GT PLL,
3411: PO_RELEASES_GT POR,PO_LINES POL, PO_HEADERS_GT POH,
3412: FINANCIALS_SYSTEM_PARAMETERS FSP
3413: WHERE POR.po_release_id = p_document_id
3414: AND POR.po_header_id = POH.po_header_id
3415: AND POR.po_header_id = POL.po_header_id

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

3544: 0,
3545: p_sequence + ROWNUM,
3546: substr(g_shipmsg||g_delim||pll.shipment_num||g_delim||l_textline,1,240),
3547: 'PO_ALL_NO_ITEM'
3548: from po_releases_gt por,po_lines pl,po_line_locations_gt pll,mtl_system_items itm,po_line_types_b plt
3549: where itm.inventory_item_id = pl.item_id
3550: and pl.item_id is not null
3551:
3552: and pl.po_line_id = pll.po_line_id

Line 3601: FROM PO_RELEASES_GT POR

3597: 0,
3598: p_sequence + ROWNUM,
3599: substr(l_textline,1,240),
3600: 'PO_ON_HOLD_CANNOT_APPROVE'
3601: FROM PO_RELEASES_GT POR
3602: WHERE POR.po_release_id = p_document_id
3603: AND nvl(POR.HOLD_FLAG,'N') = 'Y';
3604:
3605: --Increment the p_sequence with number of errors reported in last query

Line 3614: from po_headers_gt poh, po_releases_gt por

3610: ---------------------------------------------------------------------------------
3611: -- bug 6530879 Releases
3612: select poh.po_header_id,poh.vendor_id, poh.vendor_site_id, poh.vendor_contact_id
3613: into l_agreement_id, l_vendor_id,l_vendor_site_id,l_vendor_contact_id
3614: from po_headers_gt poh, po_releases_gt por
3615: where poh.po_header_id = por.po_header_id
3616: and por.po_release_id = p_document_id;
3617: -- bug 6530879
3618: -- Check 20: Vendor should be valid when approving the document.

Line 3892: FROM PO_RELEASES_GT POR,

3888: 0,
3889: p_sequence + ROWNUM,
3890: substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||l_textline,1,240),
3891: 'PO_SUB_REL_SHIP_INV_MATCH_NE_R'
3892: FROM PO_RELEASES_GT POR,
3893: PO_LINE_LOCATIONS_GT PLL
3894: WHERE POR.po_release_id = PLL.po_release_id
3895: AND POR.po_release_id = p_document_id
3896: AND Nvl(PLL.LCM_FLAG,'N') = 'Y'

Line 3937: FROM PO_RELEASES_GT POR,

3933: p_sequence + ROWNUM,
3934: substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||g_distmsg||g_delim||
3935: POD.distribution_num||g_delim||l_textline, 1,240),
3936: 'PO_SUB_REL_DIST_DEST_TYPE_NE_I'
3937: FROM PO_RELEASES_GT POR,
3938: PO_LINE_LOCATIONS_GT PLL,
3939: PO_DISTRIBUTIONS_GT POD
3940: WHERE POR.po_release_id = POD.po_release_id
3941: AND POD.line_location_id = PLL.line_location_id

Line 10139: DELETE FROM po_releases_gt;

10135: DELETE FROM po_headers_gt;
10136: DELETE FROM po_lines_gt;
10137: DELETE FROM po_line_locations_gt;
10138: DELETE FROM po_distributions_gt;
10139: DELETE FROM po_releases_gt;
10140: DELETE FROM po_req_headers_gt;
10141: DELETE FROM po_req_lines_gt;
10142: DELETE FROM po_req_distributions_gt;
10143: DELETE FROM po_online_report_text_gt;

Line 10236: FROM po_releases_gt

10232: l_progress := '009';
10233: -- Get the header_id of the relevent Blanket
10234: SELECT po_header_id
10235: INTO l_blanket_header_id
10236: FROM po_releases_gt
10237: WHERE po_release_id = l_doc_id;
10238:
10239: l_progress := '010';
10240: --populate the global headers table with header of blanket/planned PO

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

11534: l_progress := '000';
11535: IF g_debug_stmt THEN
11536: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
11537: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
11538: || l_progress,'Populate PO Releases');
11539: END IF;
11540: END IF;
11541:
11542: INSERT INTO po_releases_gt(

Line 11542: INSERT INTO po_releases_gt(

11538: || l_progress,'Populate PO Releases');
11539: END IF;
11540: END IF;
11541:
11542: INSERT INTO po_releases_gt(
11543: PO_RELEASE_ID ,
11544: LAST_UPDATE_DATE ,
11545: LAST_UPDATED_BY ,
11546: PO_HEADER_ID ,

Line 11716: FROM po_releases

11712: XML_SEND_DATE ,
11713: XML_CHANGE_SEND_DATE ,
11714: CONSIGNED_CONSUMPTION_FLAG ,
11715: CBC_ACCOUNTING_DATE
11716: FROM po_releases
11717: WHERE po_release_id = p_document_id;
11718:
11719: l_progress := '001';
11720: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 12764: OR EXISTS (select null from po_releases_all h

12760: AND (h.closed_code is NULL or h.closed_code NOT IN ('FINALLY CLOSED'))
12761: AND (h.frozen_flag is NULL or h.frozen_flag <> 'Y')))
12762: AND (p_release_id(i) IS NULL
12763: --Case 2: PO Release is specified
12764: OR EXISTS (select null from po_releases_all h
12765: WHERE h.po_release_id = p_release_id(i)
12766: AND (h.authorization_status is NULL
12767: OR h.authorization_status NOT IN ('PRE-APPROVED', 'IN PROCESS'))
12768: AND (h.cancel_flag is null or h.cancel_flag <> 'Y')

Line 12992: OR EXISTS (select null from po_releases_all h

12988: AND (h.user_hold_flag is NULL or h.user_hold_flag <> 'Y')))
12989: AND (p_release_id(i) IS NULL
12990: --Case 2: PO Release is specified
12991: -- Bug 3407980: Modified closed_code condition so that it only discards 'FINALLY CLOSED'
12992: OR EXISTS (select null from po_releases_all h
12993: WHERE h.po_release_id = p_release_id(i)
12994: AND (h.authorization_status is NULL
12995: OR h.authorization_status NOT IN ('APPROVED'))
12996: AND (h.closed_code is NULL or h.closed_code <> 'FINALLY CLOSED')

Line 13163: OR EXISTS (select null from po_releases_all h

13159: AND (h.user_hold_flag is NULL or h.user_hold_flag <> 'Y')))
13160: AND (p_release_id(i) IS NULL
13161: --Case 2: PO Release is specified
13162: -- Bug 3407980: Modified closed_code condition so that it only discards 'FINALLY CLOSED'
13163: OR EXISTS (select null from po_releases_all h
13164: WHERE h.po_release_id = p_release_id(i)
13165: AND (h.closed_code is NULL or h.closed_code <> 'FINALLY CLOSED')
13166: AND (h.frozen_flag is NULL or h.frozen_flag <> 'Y')
13167: AND (h.hold_flag is NULL or h.hold_flag <> 'Y')))

Line 13331: FROM po_releases_all h

13327: ' ' dummy, ' ' dummy, ' ' dummy,
13328: NVL(authorization_status, 'INCOMPLETE'), nvl(approved_flag, 'N'),
13329: nvl(closed_code, 'OPEN'), NVL(cancel_flag, 'N'),
13330: NVL(frozen_flag, 'N'), NVL(hold_flag, 'N'), l_sequence(i)
13331: FROM po_releases_all h
13332: WHERE h.po_release_id = p_release_id(i)
13333: ;
13334:
13335: --IF line ID present at an index, overwrite the status fields with Line Level status

Line 15718: FROM po_releases_gt por

15714: , 0
15715: , p_sequence + ROWNUM
15716: , substr(l_textline, 1, 240)
15717: , 'PO_CAN_REL_WITH_RCV_TRX'
15718: FROM po_releases_gt por
15719: WHERE EXISTS
15720: (
15721: SELECT 'Eligible shipment'
15722: FROM po_line_locations_gt poll

Line 17519: FROM po_releases_gt por

17515: , null -- distribution_num
17516: , p_sequence + ROWNUM
17517: , substr(l_textline, 1, 240)
17518: , l_message_name
17519: FROM po_releases_gt por
17520: WHERE por.po_release_id=p_doc_level_id
17521: 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;
17522:
17523: --