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_COMMUNICATION_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 1388: (ad.pk1_value in (select to_char(line_location_id) from po_line_locations_all

1384: where po_header_id = l_po_header_id
1385: and from_line_id is not null
1386: ) and ad.entity_name = 'PO_LINES')
1387: OR
1388: (ad.pk1_value in (select to_char(line_location_id) from po_line_locations_all
1389: where po_header_id = l_po_header_id
1390: and shipment_type in ('PRICE BREAK', 'STANDARD', 'PREPAYMENT') --
1391: ) and ad.entity_name = 'PO_SHIPMENTS')
1392: OR

Line 1430: (ad.pk1_value in (select to_char(po_line_id) from po_line_locations_all

1426: where pra.po_release_id = l_po_release_id
1427: and pha.po_header_id = pra.po_header_id
1428: )) and ad.entity_name = 'PO_VENDORS')
1429: OR
1430: (ad.pk1_value in (select to_char(po_line_id) from po_line_locations_all
1431: where po_release_id = l_po_release_id
1432: and shipment_type = 'BLANKET'
1433: ) and ad.entity_name = 'PO_LINES')
1434: OR

Line 1435: (ad.pk1_value in (select to_char(line_location_id) from po_line_locations_all

1431: where po_release_id = l_po_release_id
1432: and shipment_type = 'BLANKET'
1433: ) and ad.entity_name = 'PO_LINES')
1434: OR
1435: (ad.pk1_value in (select to_char(line_location_id) from po_line_locations_all
1436: where po_release_id = l_po_release_id
1437: and shipment_type = 'BLANKET'
1438: ) and ad.entity_name = 'PO_SHIPMENTS')
1439: OR

Line 1441: from po_lines_all pl, po_line_locations_all pll

1437: and shipment_type = 'BLANKET'
1438: ) and ad.entity_name = 'PO_SHIPMENTS')
1439: OR
1440: (ad.pk2_value in (select pl.item_id
1441: from po_lines_all pl, po_line_locations_all pll
1442: where pll.po_release_id = l_po_release_id
1443: and pll.shipment_type = 'BLANKET'
1444: and pll.po_line_id = pl.po_line_id
1445: and to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) = ad.pk1_value --Bug 4673653 Use Inventory OrgId

Line 1644: (ad.pk1_value in (select to_char(po_line_id) from po_line_locations_all

1640: where pra.po_release_id = l_document_id
1641: and pha.po_header_id = pra.po_header_id
1642: ) and ad.entity_name = 'PO_VENDORS')
1643: OR
1644: (ad.pk1_value in (select to_char(po_line_id) from po_line_locations_all
1645: where po_release_id = l_document_id
1646: and shipment_type = 'BLANKET'
1647: ) and ad.entity_name = 'PO_LINES')
1648: OR

Line 1649: (ad.pk1_value in (select to_char(line_location_id) from po_line_locations_all

1645: where po_release_id = l_document_id
1646: and shipment_type = 'BLANKET'
1647: ) and ad.entity_name = 'PO_LINES')
1648: OR
1649: (ad.pk1_value in (select to_char(line_location_id) from po_line_locations_all
1650: where po_release_id = l_document_id
1651: and shipment_type = 'BLANKET'
1652: ) and ad.entity_name = 'PO_SHIPMENTS')
1653: OR

Line 1655: from po_lines_all pl, po_line_locations_all pll

1651: and shipment_type = 'BLANKET'
1652: ) and ad.entity_name = 'PO_SHIPMENTS')
1653: OR
1654: (ad.pk2_value in (select pl.item_id
1655: from po_lines_all pl, po_line_locations_all pll
1656: where pll.po_release_id = l_document_id
1657: and pll.shipment_type = 'BLANKET'
1658: and pll.po_line_id = pl.po_line_id
1659: and to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) = ad.pk1_value --Bug 4673653 Use Inventory OrgId

Line 1714: (ad.pk1_value in (select to_char(line_location_id) from po_line_locations_all

1710: where po_header_id = l_document_id
1711: and from_line_id is not null
1712: ) and ad.entity_name = 'PO_LINES')
1713: OR
1714: (ad.pk1_value in (select to_char(line_location_id) from po_line_locations_all
1715: where po_header_id = l_document_id
1716: and shipment_type in ('PRICE BREAK', 'STANDARD', 'PREPAYMENT') --
1717: ) and ad.entity_name = 'PO_SHIPMENTS')
1718: OR

Line 4595: (ad.pk1_value in (select po_line_id from po_line_locations_all

4591: fnd_doc_category_usages dcu,
4592: fnd_attachment_functions af,
4593: fnd_lobs fl
4594: where (
4595: (ad.pk1_value in (select po_line_id from po_line_locations_all
4596: where po_release_id=p_document_id
4597: and shipment_type='BLANKET'
4598: ) and ad.entity_name='PO_LINES'))
4599: and d.document_id = ad.document_id

Line 4616: (ad.pk1_value in (select line_location_id from po_line_locations_all

4612: fnd_doc_category_usages dcu,
4613: fnd_attachment_functions af,
4614: fnd_lobs fl
4615: where (
4616: (ad.pk1_value in (select line_location_id from po_line_locations_all
4617: where po_release_id=p_document_id
4618: and shipment_type='BLANKET'
4619: ) and ad.entity_name='PO_SHIPMENTS'))
4620: and d.document_id = ad.document_id

Line 4638: from po_lines_all pl, po_line_locations_all pll

4634: fnd_attachment_functions af,
4635: fnd_lobs fl
4636: where ( /*bug 13528070*/
4637: (ad.pk2_value in (select /*+ push_subq no_unnest */ pl.item_id
4638: from po_lines_all pl, po_line_locations_all pll
4639: where pll.po_release_id=p_document_id
4640: and pll.shipment_type='BLANKET'
4641: and pll.po_line_id=pl.po_line_id
4642: and pl.item_id is not null

Line 4771: (ad.pk1_value in (select line_location_id from po_line_locations_all

4767: fnd_doc_category_usages dcu,
4768: fnd_attachment_functions af,
4769: fnd_lobs fl
4770: where (
4771: (ad.pk1_value in (select line_location_id from po_line_locations_all
4772: where po_header_id=p_document_id
4773: and shipment_type in ('PRICE BREAK','STANDARD','PREPAYMENT') --
4774: ) and ad.entity_name='PO_SHIPMENTS'))
4775:

Line 4997: FROM po_line_locations_all plla

4993: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num;
4994:
4995:
4996: SELECT count(distinct(plla.SHIP_TO_LOCATION_ID)) INTO PO_COMMUNICATION_PVT.g_dist_shipto_count
4997: FROM po_line_locations_all plla
4998: WHERE plla.po_header_id = p_document_id
4999: AND NVL(plla.payment_type, 'NONE') NOT IN ('ADVANCE', 'DELIVERY'); --
5000:
5001:

Line 5062: FROM po_line_locations_all plla

5058: AND ph.po_header_id = PO_COMMUNICATION_PVT.g_release_header_id ;
5059:
5060: IF p_which_tables = 'MAIN' THEN
5061: SELECT count(distinct(plla.SHIP_TO_LOCATION_ID)) INTO PO_COMMUNICATION_PVT.g_dist_shipto_count
5062: FROM po_line_locations_all plla
5063: WHERE plla.po_release_id = p_document_id;
5064:
5065: ELSE
5066: SELECT count(distinct(plla.SHIP_TO_LOCATION_ID)) INTO PO_COMMUNICATION_PVT.g_dist_shipto_count

Line 5848: SELECT count(*) into l_count FROM po_line_locations_all WHERE po_header_id = p_document_id;

5844: FROM PO_HEADERS_XML phx WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
5845:
5846: END IF;
5847:
5848: SELECT count(*) into l_count FROM po_line_locations_all WHERE po_header_id = p_document_id;
5849:
5850: IF l_count >0 THEN
5851:
5852: /* Bug#3574748: Added the condition SHIPMENT_TYPE in ('BLANKET','STANDARD') in shipment query. */

Line 6067: SELECT count(*) into l_count FROM po_line_locations_all WHERE po_release_id = p_document_id ;

6063: l_xml_message_query || ',' || l_head_short_attachment_query || ',' || l_head_url_attachment_query || ',' || l_head_file_attachment_query ||'
6064: FROM PO_RELEASE_XML phx WHERE phx.PO_RELEASE_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
6065:
6066:
6067: SELECT count(*) into l_count FROM po_line_locations_all WHERE po_release_id = p_document_id ;
6068:
6069: IF l_count >0 THEN
6070: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6071: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name || 'Releases:','Assigning Releases line/line locations query');

Line 6098: FROM po_lines_xml plx WHERE exists (SELECT ''x'' from po_line_locations_all

6094: FROM po_line_locations_xml pllx WHERE pllx.po_release_id in (select po_release_id from PO_COMMUNICATION_GT) and pllx.po_line_id = plx.po_line_id
6095: and not exists (select ''x'' from po_line_locations_archive_all pllaa where
6096: pllaa.line_location_id = pllx.line_location_id and
6097: pllaa.cancel_flag= ''Y'' and pllaa.revision_num< PO_COMMUNICATION_PVT.getRevisionNum() ) order by pllx.shipment_num ) AS line_locations
6098: FROM po_lines_xml plx WHERE exists (SELECT ''x'' from po_line_locations_all
6099: WHERE po_line_locations_all.po_line_id = plx.po_line_id and po_release_id = phx.po_release_id and not exists (select ''x'' from po_line_locations_archive_all pllaa where
6100: pllaa.line_location_id = po_line_locations_all.line_location_id and
6101: pllaa.cancel_flag= ''Y'' and pllaa.revision_num< PO_COMMUNICATION_PVT.getRevisionNum() ) ) and plx.po_header_id = phx.po_header_id order by plx.line_num) AS lines
6102: FROM PO_RELEASE_XML phx WHERE phx.PO_RELEASE_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';

Line 6099: WHERE po_line_locations_all.po_line_id = plx.po_line_id and po_release_id = phx.po_release_id and not exists (select ''x'' from po_line_locations_archive_all pllaa where

6095: and not exists (select ''x'' from po_line_locations_archive_all pllaa where
6096: pllaa.line_location_id = pllx.line_location_id and
6097: pllaa.cancel_flag= ''Y'' and pllaa.revision_num< PO_COMMUNICATION_PVT.getRevisionNum() ) order by pllx.shipment_num ) AS line_locations
6098: FROM po_lines_xml plx WHERE exists (SELECT ''x'' from po_line_locations_all
6099: WHERE po_line_locations_all.po_line_id = plx.po_line_id and po_release_id = phx.po_release_id and not exists (select ''x'' from po_line_locations_archive_all pllaa where
6100: pllaa.line_location_id = po_line_locations_all.line_location_id and
6101: pllaa.cancel_flag= ''Y'' and pllaa.revision_num< PO_COMMUNICATION_PVT.getRevisionNum() ) ) and plx.po_header_id = phx.po_header_id order by plx.line_num) AS lines
6102: FROM PO_RELEASE_XML phx WHERE phx.PO_RELEASE_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
6103:

Line 6100: pllaa.line_location_id = po_line_locations_all.line_location_id and

6096: pllaa.line_location_id = pllx.line_location_id and
6097: pllaa.cancel_flag= ''Y'' and pllaa.revision_num< PO_COMMUNICATION_PVT.getRevisionNum() ) order by pllx.shipment_num ) AS line_locations
6098: FROM po_lines_xml plx WHERE exists (SELECT ''x'' from po_line_locations_all
6099: WHERE po_line_locations_all.po_line_id = plx.po_line_id and po_release_id = phx.po_release_id and not exists (select ''x'' from po_line_locations_archive_all pllaa where
6100: pllaa.line_location_id = po_line_locations_all.line_location_id and
6101: pllaa.cancel_flag= ''Y'' and pllaa.revision_num< PO_COMMUNICATION_PVT.getRevisionNum() ) ) and plx.po_header_id = phx.po_header_id order by plx.line_num) AS lines
6102: FROM PO_RELEASE_XML phx WHERE phx.PO_RELEASE_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
6103:
6104: END IF;

Line 6403: po_line_locations_all pllx

6399: /*l_shipmentAttachmentQuery := 'SELECT fds.long_text long_text, pllx.LINE_LOCATION_ID
6400: FROM
6401: fnd_attached_docs_form_vl fad,
6402: fnd_documents_long_text fds,
6403: po_line_locations_all pllx
6404: WHERE entity_name = ''PO_SHIPMENTS'' AND
6405: pk1_value = to_char(pllx.LINE_LOCATION_ID) AND
6406: function_name = ''PO_PRINTPO''
6407: AND fad.media_id = fds.media_id

Line 6417: po_line_locations_all pllx

6413: l_shipmentAttachmentQuery := 'SELECT PO_COMMUNICATION_PVT.get_clob(fds.rowid) long_text, pllx.LINE_LOCATION_ID
6414: FROM
6415: fnd_attached_docs_form_vl fad,
6416: fnd_documents_long_text fds,
6417: po_line_locations_all pllx
6418: WHERE entity_name = ''PO_SHIPMENTS'' AND
6419: pk1_value = to_char(pllx.LINE_LOCATION_ID) AND
6420: function_name = ''PO_PRINTPO''
6421: AND fad.media_id = fds.media_id

Line 8018: FROM po_line_locations_all pll,

8014: begin
8015:
8016: SELECT sum(AMOUNT_CANCELLED), pl.amount
8017: INTO l_canceled_amount, l_amount
8018: FROM po_line_locations_all pll,
8019: po_lines_all pl
8020: WHERE pll.po_line_id = p_po_line_id AND
8021: pll.po_header_id = p_po_header_id AND
8022: pl.po_line_id = pll.po_line_id AND