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_LINES_ALL

Line 58: g_agreementLine_number PO_LINES_ALL.LINE_NUM%type := null;

54: g_header_id PO_HEADERS_ALL.PO_HEADER_ID%type := null;
55: g_quote_number PO_HEADERS_ALL.QUOTE_VENDOR_QUOTE_NUMBER%type := null;
56: g_agreement_number PO_HEADERS_ALL.SEGMENT1%type := null;
57: g_agreement_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%type := null;
58: g_agreementLine_number PO_LINES_ALL.LINE_NUM%type := null;
59: g_line_id PO_LINES_ALL.FROM_LINE_ID%type := null;
60: g_arcBuyer_fname PER_ALL_PEOPLE_F.FIRST_NAME%type := null;
61: g_arcBuyer_lname PER_ALL_PEOPLE_F.LAST_NAME%type := null;
62: g_arcBuyer_title PER_ALL_PEOPLE_F.TITLE%type := null;

Line 59: g_line_id PO_LINES_ALL.FROM_LINE_ID%type := null;

55: g_quote_number PO_HEADERS_ALL.QUOTE_VENDOR_QUOTE_NUMBER%type := null;
56: g_agreement_number PO_HEADERS_ALL.SEGMENT1%type := null;
57: g_agreement_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%type := null;
58: g_agreementLine_number PO_LINES_ALL.LINE_NUM%type := null;
59: g_line_id PO_LINES_ALL.FROM_LINE_ID%type := null;
60: g_arcBuyer_fname PER_ALL_PEOPLE_F.FIRST_NAME%type := null;
61: g_arcBuyer_lname PER_ALL_PEOPLE_F.LAST_NAME%type := null;
62: g_arcBuyer_title PER_ALL_PEOPLE_F.TITLE%type := null;
63: g_arcAgent_id PO_HEADERS_ARCHIVE_ALL.AGENT_ID%type := null;

Line 72: g_job_id PO_LINES_ALL.JOB_ID%type := null;

68: g_vendor_address_line_3 PO_VENDOR_SITES.ADDRESS_LINE3%type := null;
69: g_vendor_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type := null;
70: g_vendor_city_state_zipInfo varchar2(500) := null;
71: g_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type := null;
72: g_job_id PO_LINES_ALL.JOB_ID%type := null;
73: g_job_name PER_JOBS_VL.name%type := null;
74: g_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
75: --Bug 4504228 START
76: g_person_id PER_ALL_PEOPLE_F.PERSON_ID%type := null;

Line 1374: (ad.pk1_value in (select to_char(po_line_id) from po_lines_all

1370: OR
1371: (ad.pk1_value = to_char((select vendor_id from po_headers_all
1372: where po_header_id = l_po_header_id)) and ad.entity_name = 'PO_VENDORS')
1373: OR
1374: (ad.pk1_value in (select to_char(po_line_id) from po_lines_all
1375: where po_header_id = l_po_header_id
1376: ) and ad.entity_name = 'PO_LINES')
1377: OR
1378: (ad.pk1_value in (select to_char(from_header_id) from po_lines_all

Line 1378: (ad.pk1_value in (select to_char(from_header_id) from po_lines_all

1374: (ad.pk1_value in (select to_char(po_line_id) from po_lines_all
1375: where po_header_id = l_po_header_id
1376: ) and ad.entity_name = 'PO_LINES')
1377: OR
1378: (ad.pk1_value in (select to_char(from_header_id) from po_lines_all
1379: where po_header_id = l_po_header_id
1380: and from_header_id is not null
1381: ) and ad.entity_name = 'PO_HEADERS')
1382: OR

Line 1383: (ad.pk1_value in (select to_char(from_line_id) from po_lines_all

1379: where po_header_id = l_po_header_id
1380: and from_header_id is not null
1381: ) and ad.entity_name = 'PO_HEADERS')
1382: OR
1383: (ad.pk1_value in (select to_char(from_line_id) from po_lines_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

Line 1393: (ad.pk2_value in (select item_id from po_lines_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
1393: (ad.pk2_value in (select item_id from po_lines_all
1394: where po_header_id = l_po_header_id
1395: and to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) = ad.pk1_value --Bug 4673653 Use Inventory OrgId
1396: and item_id is not null
1397: ) and ad.entity_name = 'MTL_SYSTEM_ITEMS')

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 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 1700: (ad.pk1_value in (select to_char(po_line_id) from po_lines_all

1696: OR
1697: (ad.pk1_value = to_char((select vendor_id from po_headers_all
1698: where po_header_id = l_document_id)) and ad.entity_name = 'PO_VENDORS')
1699: OR
1700: (ad.pk1_value in (select to_char(po_line_id) from po_lines_all
1701: where po_header_id = l_document_id
1702: ) and ad.entity_name = 'PO_LINES')
1703: OR
1704: (ad.pk1_value in (select to_char(from_header_id) from po_lines_all

Line 1704: (ad.pk1_value in (select to_char(from_header_id) from po_lines_all

1700: (ad.pk1_value in (select to_char(po_line_id) from po_lines_all
1701: where po_header_id = l_document_id
1702: ) and ad.entity_name = 'PO_LINES')
1703: OR
1704: (ad.pk1_value in (select to_char(from_header_id) from po_lines_all
1705: where po_header_id = l_document_id
1706: and from_header_id is not null
1707: ) and ad.entity_name = 'PO_HEADERS')
1708: OR

Line 1709: (ad.pk1_value in (select to_char(from_line_id) from po_lines_all

1705: where po_header_id = l_document_id
1706: and from_header_id is not null
1707: ) and ad.entity_name = 'PO_HEADERS')
1708: OR
1709: (ad.pk1_value in (select to_char(from_line_id) from po_lines_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

Line 1719: (ad.pk2_value in (select item_id from po_lines_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
1719: (ad.pk2_value in (select item_id from po_lines_all
1720: where po_header_id = l_document_id
1721: and to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) = ad.pk1_value --Bug 4673653 Use Inventory OrgId
1722: and item_id is not null
1723: ) and ad.entity_name = 'MTL_SYSTEM_ITEMS')

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 4706: (ad.pk1_value in (select to_char(po_line_id) from po_lines_all

4702: fnd_doc_category_usages dcu,
4703: fnd_attachment_functions af,
4704: fnd_lobs fl
4705: where ( /*bug 13528070 Changing to to_char*/
4706: (ad.pk1_value in (select to_char(po_line_id) from po_lines_all
4707: where po_header_id=p_document_id
4708: ) and ad.entity_name='PO_LINES'))
4709:
4710: and d.document_id = ad.document_id

Line 4727: (ad.pk1_value in (select from_header_id from po_lines_all

4723: fnd_doc_category_usages dcu,
4724: fnd_attachment_functions af,
4725: fnd_lobs fl
4726: where (
4727: (ad.pk1_value in (select from_header_id from po_lines_all
4728: where po_header_id=p_document_id
4729: and from_header_id is not null
4730: ) and ad.entity_name='PO_HEADERS'))
4731:

Line 4749: (ad.pk1_value in (select from_line_id from po_lines_all

4745: fnd_doc_category_usages dcu,
4746: fnd_attachment_functions af,
4747: fnd_lobs fl
4748: where (
4749: (ad.pk1_value in (select from_line_id from po_lines_all
4750: where po_header_id=p_document_id
4751: and from_line_id is not null
4752: ) and ad.entity_name='PO_LINES'))
4753:

Line 4793: (ad.pk2_value in (select /+ push_subq no_unnest / item_id from po_lines_all

4789: fnd_doc_category_usages dcu,
4790: fnd_attachment_functions af,
4791: fnd_lobs fl
4792: where ( /*bug 13528070*/
4793: (ad.pk2_value in (select /*+ push_subq no_unnest */ item_id from po_lines_all
4794: where po_header_id=p_document_id
4795: and item_id is not null
4796: ) and ad.entity_name='MTL_SYSTEM_ITEMS'))
4797: /*bug 13528070*/

Line 5819: SELECT count(*) into l_count FROM po_lines_all WHERE po_header_id = p_document_id;

5815: FROM PO_HEADERS_XML phx WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
5816:
5817: IF(p_document_subtype <> 'CONTRACTS') THEN -- contracts will have only headers
5818:
5819: SELECT count(*) into l_count FROM po_lines_all WHERE po_header_id = p_document_id;
5820:
5821: IF l_count >0 THEN
5822:
5823: /*

Line 6242: po_lines_all plx

6238: /*l_lineAttachQuery :='SELECT fds.long_text text, plx.po_line_id id
6239: FROM
6240: fnd_attached_docs_form_vl fad,
6241: fnd_documents_long_text fds,
6242: po_lines_all plx
6243: WHERE ((fad.entity_name=''PO_LINES'' AND fad.pk1_value=to_char(plx.po_line_id))
6244: OR
6245: (fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(plx.from_header_id)
6246: AND plx.from_header_id IS NOT NULL)

Line 6265: optimization from po_lines_all table (plx) rather than fnd_attached_document (ad).Using base tables instead of view

6261: AND plx.po_header_id = PO_COMMUNICATION_PVT.getReleaseHeaderId()
6262: order by seq_num'; --bug6133951*/
6263:
6264: /* Bug 13082363 : Improving performance of l_lineAttachQuery query using UNION ALL approach. Plus adding hint so that CBO would start
6265: optimization from po_lines_all table (plx) rather than fnd_attached_document (ad).Using base tables instead of view
6266: fnd_attached_docs_form_vl. For last part of query while fetching attachments for entity MTL_SYSTEM_ITEMS, added hint
6267: use_nl(ad) so that optimizer would perform nl join and the condition ad.pk2_value=to_char ( plx.item_id )
6268: gets evaluated at index level*/
6269: -- Bug 14476193 : Changing condition DT.media_id = fds.media_id to D.media_id = fds.media_id

Line 6279: po_lines_all plx

6275: FND_DOCUMENTS_TL DT ,
6276: FND_DOCUMENTS D ,
6277: FND_ATTACHMENT_FUNCTIONS AF,
6278: fnd_doc_category_usages DCU,
6279: po_lines_all plx
6280: WHERE ( ad.entity_name=''PO_LINES''
6281: AND ad.pk1_value=to_char ( plx.po_line_id ) )
6282: AND DCU.category_id = D.category_id
6283: AND DCU.attachment_function_id = AF.attachment_function_id

Line 6300: po_lines_all plx

6296: FND_DOCUMENTS_TL DT ,
6297: FND_DOCUMENTS D ,
6298: FND_ATTACHMENT_FUNCTIONS AF,
6299: fnd_doc_category_usages DCU,
6300: po_lines_all plx
6301: WHERE ( ad.entity_name=''PO_HEADERS''
6302: AND ad.pk1_value=to_char ( plx.from_header_id )
6303: AND plx.from_header_id IS NOT NULL )
6304: AND DCU.category_id = D.category_id

Line 6322: po_lines_all plx

6318: FND_DOCUMENTS_TL DT ,
6319: FND_DOCUMENTS D ,
6320: FND_ATTACHMENT_FUNCTIONS AF,
6321: fnd_doc_category_usages DCU,
6322: po_lines_all plx
6323: WHERE ( ad.entity_name=''PO_IN_GA_LINES''
6324: AND ad.pk1_value=to_char ( plx.from_line_id )
6325: AND plx.from_line_id IS NOT NULL )
6326: AND DCU.category_id = D.category_id

Line 6344: po_lines_all plx

6340: FND_DOCUMENTS_TL DT ,
6341: FND_DOCUMENTS D ,
6342: FND_ATTACHMENT_FUNCTIONS AF,
6343: fnd_doc_category_usages DCU,
6344: po_lines_all plx
6345: WHERE ( ad.entity_name=''PO_HEADERS''
6346: AND ad.pk1_value=to_char ( plx.CONTRACT_ID )
6347: AND plx.CONTRACT_ID IS NOT NULL )
6348: AND DCU.category_id = D.category_id

Line 6366: po_lines_all plx

6362: FND_DOCUMENTS_TL DT ,
6363: FND_DOCUMENTS D ,
6364: FND_ATTACHMENT_FUNCTIONS AF,
6365: fnd_doc_category_usages DCU,
6366: po_lines_all plx
6367: WHERE ( ad.entity_name=''MTL_SYSTEM_ITEMS''
6368: AND ad.pk1_value=to_char ( PO_COMMUNICATION_PVT.getInventoryOrgId ( ) )
6369: AND -- Bug6139548
6370: ad.pk2_value=to_char ( plx.item_id )

Line 7267: FROM PO_LINES_ALL

7263:
7264: PO_COMMUNICATION_PVT.g_line_id := p_line_id;
7265:
7266: Select LINE_NUM into PO_COMMUNICATION_PVT.g_agreementLine_number
7267: FROM PO_LINES_ALL
7268: WHERE PO_LINE_ID = p_line_id;
7269: end if;
7270: return PO_COMMUNICATION_PVT.g_agreementLine_number;
7271:

Line 8019: po_lines_all pl

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
8023: pll.CANCEL_FLAG = 'Y'

Line 8037: po_lines_all pl

8033: begin
8034: SELECT sum(AMOUNT_CANCELLED), pl.amount
8035: INTO l_canceled_amount, l_amount
8036: FROM po_line_locations_archive_all plla,
8037: po_lines_all pl
8038: WHERE plla.po_line_id = p_po_line_id AND
8039: plla.po_header_id = p_po_header_id AND
8040: plla.revision_num = p_po_revision_num AND
8041: pl.po_line_id = plla.po_line_id AND