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.

[Home] [Help]

APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on ARP_ADDR_LABEL_PKG

Line 1632: HPS.PARTY_SITE_NUMBER, SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,

1628: inv.date_invoiced SUPPLIER_INVOICE_DATE,
1629: inv.shipping_address_id1 SUPPLIER_SHIP_TO_SITE_USE_ID,
1630: HPS.PARTY_SITE_ID INV_SUPPLIER_SHIP_TO_SITE_ID,
1631: HPS.PARTY_SITE_NUMBER INV_SUPPLIER_SHIP_TO_SITE_NUM,
1632: HPS.PARTY_SITE_NUMBER, SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
1633: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
1634: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) SUPPLIER_SHIP_TO_SITE,
1635: pov.vendor_name SUPPLIER_VENDOR_NAME,
1636: cpl.object1_id1 SUPPLIER_VENDOR_ID,

Line 1736: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,

1732: cle_inst.dnz_chr_id,
1733: to_number(iti.object_id1_new) INSTALL_SITE_USE_ID,
1734: hps.party_site_id INSTALL_SITE_ID,
1735: hps.party_site_number INSTALL_SITE_NUMBER,
1736: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,
1737: hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,
1738: hl.postal_code,null,hl.country,null, null,null,null,null,null,
1739: null,'n','n',80,1,1),1,80) INSTALL_SITE_NAME,
1740: --(case when NVL(cim_ib.NUMBER_OF_ITEMS,0) > 1 THEN lookup.MEANING

Line 3743: HPS.PARTY_SITE_NUMBER, SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,

3739: inv.date_invoiced SUPPLIER_INVOICE_DATE,
3740: inv.shipping_address_id1 SUPPLIER_SHIP_TO_SITE_USE_ID,
3741: HPS.PARTY_SITE_ID INV_SUPPLIER_SHIP_TO_SITE_ID,
3742: HPS.PARTY_SITE_NUMBER INV_SUPPLIER_SHIP_TO_SITE_NUM,
3743: HPS.PARTY_SITE_NUMBER, SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
3744: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
3745: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) SUPPLIER_SHIP_TO_SITE,
3746: pov.vendor_name SUPPLIER_VENDOR_NAME,
3747: cpl.object1_id1 SUPPLIER_VENDOR_ID,

Line 3848: SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,

3844: cleb_inst.cle_id cle_id,
3845: cleb_inst.dnz_chr_id dnz_chr_id,
3846: iti.id,
3847: to_number(iti.object_id1_new) INSTALL_SITE_USE_ID,
3848: SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
3849: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
3850: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) INSTALL_SITE_NAME,
3851: hps.party_site_id INSTALL_SITE_ID,
3852: hps.party_site_number INSTALL_SITE_NUMBER,

Line 5724: HPS.PARTY_SITE_NUMBER, SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,

5720: inv.date_invoiced SUPPLIER_INVOICE_DATE,
5721: inv.shipping_address_id1 SUPPLIER_SHIP_TO_SITE_USE_ID,
5722: HPS.PARTY_SITE_ID INV_SUPPLIER_SHIP_TO_SITE_ID,
5723: HPS.PARTY_SITE_NUMBER INV_SUPPLIER_SHIP_TO_SITE_NUM,
5724: HPS.PARTY_SITE_NUMBER, SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
5725: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
5726: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) SUPPLIER_SHIP_TO_SITE,
5727: pov.vendor_name SUPPLIER_VENDOR_NAME,
5728: cpl.object1_id1 SUPPLIER_VENDOR_ID,

Line 5829: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,

5825: cle_inst.dnz_chr_id,
5826: to_number(iti.object_id1_new) INSTALL_SITE_USE_ID,
5827: hps.party_site_id INSTALL_SITE_ID,
5828: hps.party_site_number INSTALL_SITE_NUMBER,
5829: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,
5830: hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,
5831: hl.postal_code,null,hl.country,null, null,null,null,null,null,
5832: null,'n','n',80,1,1),1,80) INSTALL_SITE_NAME,
5833: -- bug 7631324

Line 5883: SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,

5879: cleb_inst.cle_id cle_id,
5880: cleb_inst.dnz_chr_id dnz_chr_id,
5881: iti.id,
5882: to_number(iti.object_id1_new) INSTALL_SITE_USE_ID,
5883: SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
5884: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
5885: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) INSTALL_SITE_NAME,
5886: hps.party_site_id INSTALL_SITE_ID,
5887: hps.party_site_number INSTALL_SITE_NUMBER,