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 1168: (ad.pk1_value in (select line_location_id from po_line_locations_all

1164: where po_header_id=l_po_header_id
1165: and from_line_id is not null
1166: ) and ad.entity_name='PO_LINES')
1167: OR
1168: (ad.pk1_value in (select line_location_id from po_line_locations_all
1169: where po_header_id=l_po_header_id
1170: and shipment_type in ('PRICE BREAK','STANDARD', 'PREPAYMENT') --
1171: ) and ad.entity_name='PO_SHIPMENTS')
1172: OR

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

1206: where pra.po_release_id=l_po_release_id
1207: and pha.po_header_id=pra.po_header_id
1208: )) and ad.entity_name='PO_VENDORS')
1209: OR
1210: (ad.pk1_value in (select po_line_id from po_line_locations_all
1211: where po_release_id=l_po_release_id
1212: and shipment_type='BLANKET'
1213: ) and ad.entity_name='PO_LINES')
1214: OR

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

1211: where po_release_id=l_po_release_id
1212: and shipment_type='BLANKET'
1213: ) and ad.entity_name='PO_LINES')
1214: OR
1215: (ad.pk1_value in (select line_location_id from po_line_locations_all
1216: where po_release_id=l_po_release_id
1217: and shipment_type='BLANKET'
1218: ) and ad.entity_name='PO_SHIPMENTS')
1219: OR

Line 1221: from po_lines_all pl, po_line_locations_all pll

1217: and shipment_type='BLANKET'
1218: ) and ad.entity_name='PO_SHIPMENTS')
1219: OR
1220: (ad.pk2_value in (select pl.item_id
1221: from po_lines_all pl, po_line_locations_all pll
1222: where pll.po_release_id=l_po_release_id
1223: and pll.shipment_type='BLANKET'
1224: and pll.po_line_id=pl.po_line_id
1225: and to_char(PO_COMMUNICATION_PVT.getInventoryOrgId())=ad.pk1_value --Bug 4673653 Use Inventory OrgId

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

1394: where pra.po_release_id=l_document_id
1395: and pha.po_header_id=pra.po_header_id
1396: ) and ad.entity_name='PO_VENDORS')
1397: OR
1398: (ad.pk1_value in (select po_line_id from po_line_locations_all
1399: where po_release_id=l_document_id
1400: and shipment_type='BLANKET'
1401: ) and ad.entity_name='PO_LINES')
1402: OR

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

1399: where po_release_id=l_document_id
1400: and shipment_type='BLANKET'
1401: ) and ad.entity_name='PO_LINES')
1402: OR
1403: (ad.pk1_value in (select line_location_id from po_line_locations_all
1404: where po_release_id=l_document_id
1405: and shipment_type='BLANKET'
1406: ) and ad.entity_name='PO_SHIPMENTS')
1407: OR

Line 1409: from po_lines_all pl, po_line_locations_all pll

1405: and shipment_type='BLANKET'
1406: ) and ad.entity_name='PO_SHIPMENTS')
1407: OR
1408: (ad.pk2_value in (select pl.item_id
1409: from po_lines_all pl, po_line_locations_all pll
1410: where pll.po_release_id=l_document_id
1411: and pll.shipment_type='BLANKET'
1412: and pll.po_line_id=pl.po_line_id
1413: and to_char(PO_COMMUNICATION_PVT.getInventoryOrgId())=ad.pk1_value --Bug 4673653 Use Inventory OrgId

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

1464: where po_header_id=l_document_id
1465: and from_line_id is not null
1466: ) and ad.entity_name='PO_LINES')
1467: OR
1468: (ad.pk1_value in (select line_location_id from po_line_locations_all
1469: where po_header_id=l_document_id
1470: and shipment_type in ('PRICE BREAK','STANDARD','PREPAYMENT') --
1471: ) and ad.entity_name='PO_SHIPMENTS')
1472: OR

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

3987: where pra.po_release_id=p_document_id
3988: and pha.po_header_id=pra.po_header_id
3989: )) and ad.entity_name='PO_VENDORS')
3990: OR
3991: (ad.pk1_value in (select po_line_id from po_line_locations_all
3992: where po_release_id=p_document_id
3993: and shipment_type='BLANKET'
3994: ) and ad.entity_name='PO_LINES')
3995: OR

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

3992: where po_release_id=p_document_id
3993: and shipment_type='BLANKET'
3994: ) and ad.entity_name='PO_LINES')
3995: OR
3996: (ad.pk1_value in (select line_location_id from po_line_locations_all
3997: where po_release_id=p_document_id
3998: and shipment_type='BLANKET'
3999: ) and ad.entity_name='PO_SHIPMENTS')
4000: OR

Line 4002: from po_lines_all pl, po_line_locations_all pll

3998: and shipment_type='BLANKET'
3999: ) and ad.entity_name='PO_SHIPMENTS')
4000: OR
4001: (ad.pk2_value in (select pl.item_id
4002: from po_lines_all pl, po_line_locations_all pll
4003: where pll.po_release_id=p_document_id
4004: and pll.shipment_type='BLANKET'
4005: and pll.po_line_id=pl.po_line_id
4006: and to_char(PO_COMMUNICATION_PVT.getInventoryOrgId())=ad.pk1_value --Bug 4673653 Use Inventory OrgId

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

4047: where po_header_id=p_document_id
4048: and from_line_id is not null
4049: ) and ad.entity_name='PO_LINES')
4050: OR
4051: (ad.pk1_value in (select line_location_id from po_line_locations_all
4052: where po_header_id=p_document_id
4053: and shipment_type in ('PRICE BREAK','STANDARD','PREPAYMENT') --
4054: ) and ad.entity_name='PO_SHIPMENTS')
4055: OR

Line 4239: FROM po_line_locations_all plla

4235: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num;
4236:
4237:
4238: SELECT count(distinct(plla.SHIP_TO_LOCATION_ID)) INTO PO_COMMUNICATION_PVT.g_dist_shipto_count
4239: FROM po_line_locations_all plla
4240: WHERE plla.po_header_id = p_document_id
4241: AND NVL(plla.payment_type, 'NONE') NOT IN ('ADVANCE', 'DELIVERY'); --
4242:
4243:

Line 4304: FROM po_line_locations_all plla

4300: AND ph.po_header_id = PO_COMMUNICATION_PVT.g_release_header_id ;
4301:
4302: IF p_which_tables = 'MAIN' THEN
4303: SELECT count(distinct(plla.SHIP_TO_LOCATION_ID)) INTO PO_COMMUNICATION_PVT.g_dist_shipto_count
4304: FROM po_line_locations_all plla
4305: WHERE plla.po_release_id = p_document_id;
4306:
4307: ELSE
4308: SELECT count(distinct(plla.SHIP_TO_LOCATION_ID)) INTO PO_COMMUNICATION_PVT.g_dist_shipto_count

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

4990: FROM PO_HEADERS_XML phx WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
4991:
4992: END IF;
4993:
4994: SELECT count(*) into l_count FROM po_line_locations_all WHERE po_header_id = p_document_id;
4995:
4996: IF l_count >0 THEN
4997:
4998: /* Bug#3574748: Added the condition SHIPMENT_TYPE in ('BLANKET','STANDARD') in shipment query. */

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

5192: l_xml_message_query || ','|| l_head_short_attachment_query ||','||l_head_url_attachment_query||','||l_head_file_attachment_query||'
5193: FROM PO_RELEASE_XML phx WHERE phx.PO_RELEASE_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
5194:
5195:
5196: SELECT count(*) into l_count FROM po_line_locations_all WHERE po_release_id = p_document_id ;
5197:
5198: IF l_count >0 THEN
5199: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5200: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Releases:','Assigning Releases line/line locations query');

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

5216: 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
5217: and not exists (select ''x'' from po_line_locations_archive_all pllaa where
5218: pllaa.line_location_id = pllx.line_location_id and
5219: pllaa.cancel_flag= ''Y'' and pllaa.revision_num< PO_COMMUNICATION_PVT.getRevisionNum() ) order by pllx.shipment_num ) AS line_locations
5220: FROM po_lines_xml plx WHERE exists (SELECT ''x'' from po_line_locations_all
5221: 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
5222: pllaa.line_location_id = po_line_locations_all.line_location_id and
5223: 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
5224: FROM PO_RELEASE_XML phx WHERE phx.PO_RELEASE_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';

Line 5221: 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

5217: and not exists (select ''x'' from po_line_locations_archive_all pllaa where
5218: pllaa.line_location_id = pllx.line_location_id and
5219: pllaa.cancel_flag= ''Y'' and pllaa.revision_num< PO_COMMUNICATION_PVT.getRevisionNum() ) order by pllx.shipment_num ) AS line_locations
5220: FROM po_lines_xml plx WHERE exists (SELECT ''x'' from po_line_locations_all
5221: 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
5222: pllaa.line_location_id = po_line_locations_all.line_location_id and
5223: 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
5224: FROM PO_RELEASE_XML phx WHERE phx.PO_RELEASE_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
5225:

Line 5222: pllaa.line_location_id = po_line_locations_all.line_location_id and

5218: pllaa.line_location_id = pllx.line_location_id and
5219: pllaa.cancel_flag= ''Y'' and pllaa.revision_num< PO_COMMUNICATION_PVT.getRevisionNum() ) order by pllx.shipment_num ) AS line_locations
5220: FROM po_lines_xml plx WHERE exists (SELECT ''x'' from po_line_locations_all
5221: 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
5222: pllaa.line_location_id = po_line_locations_all.line_location_id and
5223: 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
5224: FROM PO_RELEASE_XML phx WHERE phx.PO_RELEASE_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
5225:
5226: END IF;

Line 5382: po_line_locations_all pllx

5378: l_shipmentAttachmentQuery:= 'SELECT PO_COMMUNICATION_PVT.get_clob(fds.rowid) long_text, pllx.LINE_LOCATION_ID
5379: FROM
5380: fnd_attached_docs_form_vl fad,
5381: fnd_documents_long_text fds,
5382: po_line_locations_all pllx
5383: WHERE entity_name = ''PO_SHIPMENTS'' AND
5384: pk1_value = to_char(pllx.LINE_LOCATION_ID) AND
5385: function_name = ''PO_PRINTPO''
5386: AND fad.media_id = fds.media_id

Line 6826: FROM po_line_locations_all pll,

6822: begin
6823:
6824: SELECT sum(AMOUNT_CANCELLED), pl.amount
6825: INTO l_canceled_amount, l_amount
6826: FROM po_line_locations_all pll,
6827: po_lines_all pl
6828: WHERE pll.po_line_id = p_po_line_id AND
6829: pll.po_header_id = p_po_header_id AND
6830: pl.po_line_id = pll.po_line_id AND