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_COMMUNICATION_GT

Line 4288: insert into PO_COMMUNICATION_GT(po_header_id, po_release_id, revision_number, format_mask)

4284: -- bug#3698674: inserted header/release id and revision num into global temp table
4285: -- bug#3823799: Moved the query from top to here to insert data in table based on the document type.
4286: -- po_release_id is inserted as null
4287: -- bug#3853109: Added the column names in the insert clause as per the review comments
4288: insert into PO_COMMUNICATION_GT(po_header_id, po_release_id, revision_number, format_mask)
4289: values(p_document_id, null, p_revision_num, PO_COMMUNICATION_PVT.getFormatMask);
4290: ELSE
4291: -- Modified as a part of bug #3274076
4292: -- Vendor id is same for revisied and non revised documents. So vendor id is retreived from the releases table.

Line 4318: insert into PO_COMMUNICATION_GT(po_header_id, po_release_id, revision_number, format_mask)

4314: -- bug#3698674: inserted header/release id and revision num into global temp table
4315: -- bug#3823799: Moved the query from top to here to insert data in table based on the document type.
4316: -- po_header_id is inserted as null
4317: -- bug#3853109: Added the column names in the insert clause as per the review comments
4318: insert into PO_COMMUNICATION_GT(po_header_id, po_release_id, revision_number, format_mask)
4319: values(null, p_document_id, p_revision_num, PO_COMMUNICATION_PVT.getFormatMask);
4320: END IF;
4321:
4322: EXCEPTION

Line 5102: FROM PO_HEADERS_ARCHIVE_XML phx, PO_COMMUNICATION_GT pcgt

5098: WHERE entity_type='''||l_eventType||''' AND entity_id = plx.po_line_id and enabled_flag=''Y'') AS price_diff,
5099: '|| l_line_short_attachment_query ||','||l_line_url_attachment_query||','||l_line_file_attachment_query||' FROM PO_LINES_ARCHIVE_XML plx WHERE plx.po_header_id = phx.po_header_id
5100: AND plx.REVISION_NUM = (select max(revision_num) from po_lines_archive_all pla where pla.po_line_id = plx.po_line_id
5101: and pla.revision_num <= pcgt.revision_number ) and ''Y'' = decode(nvl(plx.cancel_flag,''N''),''N'',''Y'',''Y'',decode(plx.revision_num,PO_COMMUNICATION_PVT.getRevisionNum(),''Y'',''N'') ) order by plx.line_num) AS lines
5102: FROM PO_HEADERS_ARCHIVE_XML phx, PO_COMMUNICATION_GT pcgt
5103: WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId()
5104: AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
5105:
5106: END IF;

Line 5136: FROM PO_HEADERS_ARCHIVE_XML phx, PO_COMMUNICATION_GT pcgt WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';

5132: and ''Y'' = decode(nvl(pllx.cancel_flag,''N''),''N'',''Y'',''Y'',decode(pllx.revision_num,PO_COMMUNICATION_PVT.getRevisionNum(),''Y'',''N'') ) order by pllx.shipment_num ) AS line_locations' || l_complex_lloc_query || '
5133: FROM PO_LINES_ARCHIVE_XML plx WHERE plx.po_header_id = phx.po_header_id
5134: AND plx.REVISION_NUM = (select max(revision_num) from po_lines_archive_all pla where pla.po_line_id = plx.po_line_id
5135: and pla.revision_num <= pcgt.revision_number ) and ''Y'' = decode(nvl(plx.cancel_flag,''N''),''N'',''Y'',''Y'',decode(plx.revision_num,PO_COMMUNICATION_PVT.getRevisionNum(),''Y'',''N'') ) order by plx.line_num) AS lines
5136: FROM PO_HEADERS_ARCHIVE_XML phx, PO_COMMUNICATION_GT pcgt WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
5137: END IF;
5138:
5139: IF(p_document_subtype <> 'BLANKET') THEN -- blankets will not have distributions
5140: SELECT count(*) into l_count FROM po_distributions_archive_all WHERE po_header_id = p_document_id;

Line 5165: FROM PO_HEADERS_ARCHIVE_XML phx, PO_COMMUNICATION_GT pcgt WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND

5161: and ''Y'' = decode(nvl(pllx.cancel_flag,''N''),''N'',''Y'',''Y'',decode(pllx.revision_num,PO_COMMUNICATION_PVT.getRevisionNum(),''Y'',''N'') ) order by pllx.shipment_num ) AS line_locations'|| l_complex_dist_query || '
5162: FROM PO_LINES_ARCHIVE_XML plx WHERE plx.po_header_id = phx.po_header_id
5163: AND plx.REVISION_NUM = (select max(revision_num) from po_lines_archive_all pla where pla.po_line_id = plx.po_line_id
5164: and pla.revision_num <= pcgt.revision_number ) and ''Y'' = decode(nvl(plx.cancel_flag,''N''),''N'',''Y'',''Y'',decode(plx.revision_num,PO_COMMUNICATION_PVT.getRevisionNum(),''Y'',''N'') ) order by plx.line_num) AS lines
5165: FROM PO_HEADERS_ARCHIVE_XML phx, PO_COMMUNICATION_GT pcgt WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND
5166: phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
5167:
5168: END IF; -- end of
5169: END IF; -- end of balnket if condition

Line 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

5212: '|| l_line_short_attachment_query ||','||l_line_url_attachment_query||','||l_line_file_attachment_query||',
5213: CURSOR(SELECT pllx.*,'|| l_shipment_short_attach_query ||','||l_shipment_url_attach_query||','||l_shipment_file_attach_query||',
5214: CURSOR(SELECT pd.*
5215: FROM po_distribution_xml pd WHERE pd.po_release_id = pllx.po_release_id and pd.LINE_LOCATION_ID = pllx.LINE_LOCATION_ID) AS distributions
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

Line 5272: FROM PO_RELEASE_ARCHIVE_XML phx, PO_COMMUNICATION_GT pcgt WHERE phx.PO_RELEASE_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';

5268: and pr.po_release_id = pcgt.po_release_id
5269: and pr.revision_num= pcgt.revision_number
5270: and pb.approved_date <= pr.approved_date
5271: ) ) order by plx.line_num desc) AS lines
5272: FROM PO_RELEASE_ARCHIVE_XML phx, PO_COMMUNICATION_GT pcgt WHERE phx.PO_RELEASE_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
5273:
5274: END IF;
5275:
5276:

Line 5529: DELETE po_communication_gt ; -- Added this line for bug:3698674

5525: END IF;
5526:
5527: /*Delete the records from global temp table*/
5528: DELETE po_address_details_gt;
5529: DELETE po_communication_gt ; -- Added this line for bug:3698674
5530:
5531:
5532:
5533: