DBA Data[Home] [Help]

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

1150: OR
1151: (ad.pk1_value=to_char((select vendor_id from po_headers_all
1152: where po_header_id=l_po_header_id)) and ad.entity_name='PO_VENDORS')
1153: OR
1154: (ad.pk1_value in (select po_line_id from po_lines_all
1155: where po_header_id=l_po_header_id
1156: ) and ad.entity_name='PO_LINES')
1157: OR
1158: (ad.pk1_value in (select from_header_id from po_lines_all

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

1154: (ad.pk1_value in (select po_line_id from po_lines_all
1155: where po_header_id=l_po_header_id
1156: ) and ad.entity_name='PO_LINES')
1157: OR
1158: (ad.pk1_value in (select from_header_id from po_lines_all
1159: where po_header_id=l_po_header_id
1160: and from_header_id is not null
1161: ) and ad.entity_name='PO_HEADERS')
1162: OR

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

1159: where po_header_id=l_po_header_id
1160: and from_header_id is not null
1161: ) and ad.entity_name='PO_HEADERS')
1162: OR
1163: (ad.pk1_value in (select from_line_id from po_lines_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

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

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

1450: OR
1451: (ad.pk1_value=to_char((select vendor_id from po_headers_all
1452: where po_header_id=l_document_id)) and ad.entity_name='PO_VENDORS')
1453: OR
1454: (ad.pk1_value in (select po_line_id from po_lines_all
1455: where po_header_id=l_document_id
1456: ) and ad.entity_name='PO_LINES')
1457: OR
1458: (ad.pk1_value in (select from_header_id from po_lines_all

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

1454: (ad.pk1_value in (select po_line_id from po_lines_all
1455: where po_header_id=l_document_id
1456: ) and ad.entity_name='PO_LINES')
1457: OR
1458: (ad.pk1_value in (select from_header_id from po_lines_all
1459: where po_header_id=l_document_id
1460: and from_header_id is not null
1461: ) and ad.entity_name='PO_HEADERS')
1462: OR

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

1459: where po_header_id=l_document_id
1460: and from_header_id is not null
1461: ) and ad.entity_name='PO_HEADERS')
1462: OR
1463: (ad.pk1_value in (select from_line_id from po_lines_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

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

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

4033: OR
4034: (ad.pk1_value=to_char((select vendor_id from po_headers_all
4035: where po_header_id=p_document_id)) and ad.entity_name='PO_VENDORS')
4036: OR
4037: (ad.pk1_value in (select po_line_id from po_lines_all
4038: where po_header_id=p_document_id
4039: ) and ad.entity_name='PO_LINES')
4040: OR
4041: (ad.pk1_value in (select from_header_id from po_lines_all

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

4037: (ad.pk1_value in (select po_line_id from po_lines_all
4038: where po_header_id=p_document_id
4039: ) and ad.entity_name='PO_LINES')
4040: OR
4041: (ad.pk1_value in (select from_header_id from po_lines_all
4042: where po_header_id=p_document_id
4043: and from_header_id is not null
4044: ) and ad.entity_name='PO_HEADERS')
4045: OR

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

4042: where po_header_id=p_document_id
4043: and from_header_id is not null
4044: ) and ad.entity_name='PO_HEADERS')
4045: OR
4046: (ad.pk1_value in (select from_line_id from po_lines_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

Line 4056: (ad.pk2_value in (select item_id from po_lines_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
4056: (ad.pk2_value in (select item_id from po_lines_all
4057: where po_header_id=p_document_id
4058: and to_char(PO_COMMUNICATION_PVT.getInventoryOrgId())=ad.pk1_value --Bug 4673653 Use Inventory OrgId
4059: and item_id is not null
4060: ) and ad.entity_name='MTL_SYSTEM_ITEMS')

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

4962: FROM PO_HEADERS_XML phx WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
4963:
4964: IF(p_document_subtype <> 'CONTRACTS') THEN -- contracts will have only headers
4965:
4966: SELECT count(*) into l_count FROM po_lines_all WHERE po_header_id = p_document_id;
4967:
4968: IF l_count >0 THEN
4969:
4970: /*

Line 5353: po_lines_all plx

5349: l_lineAttachQuery :='SELECT PO_COMMUNICATION_PVT.get_clob(fds.rowid) text, plx.po_line_id id
5350: FROM
5351: fnd_attached_docs_form_vl fad,
5352: fnd_documents_long_text fds,
5353: po_lines_all plx
5354: WHERE ((fad.entity_name=''PO_LINES'' AND fad.pk1_value=to_char(plx.po_line_id))
5355: OR
5356: (fad.entity_name=''MTL_SYSTEM_ITEMS'' AND
5357: fad.pk1_value=to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) AND --Bug6139548

Line 6159: FROM PO_LINES_ALL

6155:
6156: PO_COMMUNICATION_PVT.g_line_id := p_line_id;
6157:
6158: Select LINE_NUM into PO_COMMUNICATION_PVT.g_agreementLine_number
6159: FROM PO_LINES_ALL
6160: WHERE PO_LINE_ID = p_line_id;
6161: end if;
6162: return PO_COMMUNICATION_PVT.g_agreementLine_number;
6163:

Line 6827: po_lines_all pl

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

Line 6845: po_lines_all pl

6841: begin
6842: SELECT sum(AMOUNT_CANCELLED), pl.amount
6843: INTO l_canceled_amount, l_amount
6844: FROM po_line_locations_archive_all plla,
6845: po_lines_all pl
6846: WHERE plla.po_line_id = p_po_line_id AND
6847: plla.po_header_id = p_po_header_id AND
6848: plla.revision_num = p_po_revision_num AND
6849: pl.po_line_id = plla.po_line_id AND