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.OKL_K_LINE_FIN_EXT_PVT dependencies on ARP_ADDR_LABEL_PKG

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

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

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

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

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

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

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

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

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

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

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

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

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

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