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.OKC_OC_INT_KTQ_PVT dependencies on OKX_CUST_SITE_USES_V

Line 655: party_site_id okx_cust_site_uses_v.party_site_id%TYPE,

651: (
652: chr_id okc_k_headers_b.id%TYPE,
653: cle_id okc_k_lines_b.id%TYPE,
654: --
655: party_site_id okx_cust_site_uses_v.party_site_id%TYPE,
656: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,
657: party_id okx_cust_site_uses_v.party_id%TYPE,
658: address1 okx_cust_site_uses_v.address1%TYPE,
659: address2 okx_cust_site_uses_v.address2%TYPE,

Line 656: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,

652: chr_id okc_k_headers_b.id%TYPE,
653: cle_id okc_k_lines_b.id%TYPE,
654: --
655: party_site_id okx_cust_site_uses_v.party_site_id%TYPE,
656: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,
657: party_id okx_cust_site_uses_v.party_id%TYPE,
658: address1 okx_cust_site_uses_v.address1%TYPE,
659: address2 okx_cust_site_uses_v.address2%TYPE,
660: address3 okx_cust_site_uses_v.address3%TYPE,

Line 657: party_id okx_cust_site_uses_v.party_id%TYPE,

653: cle_id okc_k_lines_b.id%TYPE,
654: --
655: party_site_id okx_cust_site_uses_v.party_site_id%TYPE,
656: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,
657: party_id okx_cust_site_uses_v.party_id%TYPE,
658: address1 okx_cust_site_uses_v.address1%TYPE,
659: address2 okx_cust_site_uses_v.address2%TYPE,
660: address3 okx_cust_site_uses_v.address3%TYPE,
661: address4 okx_cust_site_uses_v.address4%TYPE,

Line 658: address1 okx_cust_site_uses_v.address1%TYPE,

654: --
655: party_site_id okx_cust_site_uses_v.party_site_id%TYPE,
656: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,
657: party_id okx_cust_site_uses_v.party_id%TYPE,
658: address1 okx_cust_site_uses_v.address1%TYPE,
659: address2 okx_cust_site_uses_v.address2%TYPE,
660: address3 okx_cust_site_uses_v.address3%TYPE,
661: address4 okx_cust_site_uses_v.address4%TYPE,
662: city okx_cust_site_uses_v.city%TYPE,

Line 659: address2 okx_cust_site_uses_v.address2%TYPE,

655: party_site_id okx_cust_site_uses_v.party_site_id%TYPE,
656: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,
657: party_id okx_cust_site_uses_v.party_id%TYPE,
658: address1 okx_cust_site_uses_v.address1%TYPE,
659: address2 okx_cust_site_uses_v.address2%TYPE,
660: address3 okx_cust_site_uses_v.address3%TYPE,
661: address4 okx_cust_site_uses_v.address4%TYPE,
662: city okx_cust_site_uses_v.city%TYPE,
663: postal_code okx_cust_site_uses_v.postal_code%TYPE,

Line 660: address3 okx_cust_site_uses_v.address3%TYPE,

656: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,
657: party_id okx_cust_site_uses_v.party_id%TYPE,
658: address1 okx_cust_site_uses_v.address1%TYPE,
659: address2 okx_cust_site_uses_v.address2%TYPE,
660: address3 okx_cust_site_uses_v.address3%TYPE,
661: address4 okx_cust_site_uses_v.address4%TYPE,
662: city okx_cust_site_uses_v.city%TYPE,
663: postal_code okx_cust_site_uses_v.postal_code%TYPE,
664: state okx_cust_site_uses_v.state%TYPE,

Line 661: address4 okx_cust_site_uses_v.address4%TYPE,

657: party_id okx_cust_site_uses_v.party_id%TYPE,
658: address1 okx_cust_site_uses_v.address1%TYPE,
659: address2 okx_cust_site_uses_v.address2%TYPE,
660: address3 okx_cust_site_uses_v.address3%TYPE,
661: address4 okx_cust_site_uses_v.address4%TYPE,
662: city okx_cust_site_uses_v.city%TYPE,
663: postal_code okx_cust_site_uses_v.postal_code%TYPE,
664: state okx_cust_site_uses_v.state%TYPE,
665: province okx_cust_site_uses_v.province%TYPE,

Line 662: city okx_cust_site_uses_v.city%TYPE,

658: address1 okx_cust_site_uses_v.address1%TYPE,
659: address2 okx_cust_site_uses_v.address2%TYPE,
660: address3 okx_cust_site_uses_v.address3%TYPE,
661: address4 okx_cust_site_uses_v.address4%TYPE,
662: city okx_cust_site_uses_v.city%TYPE,
663: postal_code okx_cust_site_uses_v.postal_code%TYPE,
664: state okx_cust_site_uses_v.state%TYPE,
665: province okx_cust_site_uses_v.province%TYPE,
666: county okx_cust_site_uses_v.county%TYPE,

Line 663: postal_code okx_cust_site_uses_v.postal_code%TYPE,

659: address2 okx_cust_site_uses_v.address2%TYPE,
660: address3 okx_cust_site_uses_v.address3%TYPE,
661: address4 okx_cust_site_uses_v.address4%TYPE,
662: city okx_cust_site_uses_v.city%TYPE,
663: postal_code okx_cust_site_uses_v.postal_code%TYPE,
664: state okx_cust_site_uses_v.state%TYPE,
665: province okx_cust_site_uses_v.province%TYPE,
666: county okx_cust_site_uses_v.county%TYPE,
667: country okx_cust_site_uses_v.country%TYPE);

Line 664: state okx_cust_site_uses_v.state%TYPE,

660: address3 okx_cust_site_uses_v.address3%TYPE,
661: address4 okx_cust_site_uses_v.address4%TYPE,
662: city okx_cust_site_uses_v.city%TYPE,
663: postal_code okx_cust_site_uses_v.postal_code%TYPE,
664: state okx_cust_site_uses_v.state%TYPE,
665: province okx_cust_site_uses_v.province%TYPE,
666: county okx_cust_site_uses_v.county%TYPE,
667: country okx_cust_site_uses_v.country%TYPE);
668:

Line 665: province okx_cust_site_uses_v.province%TYPE,

661: address4 okx_cust_site_uses_v.address4%TYPE,
662: city okx_cust_site_uses_v.city%TYPE,
663: postal_code okx_cust_site_uses_v.postal_code%TYPE,
664: state okx_cust_site_uses_v.state%TYPE,
665: province okx_cust_site_uses_v.province%TYPE,
666: county okx_cust_site_uses_v.county%TYPE,
667: country okx_cust_site_uses_v.country%TYPE);
668:
669:

Line 666: county okx_cust_site_uses_v.county%TYPE,

662: city okx_cust_site_uses_v.city%TYPE,
663: postal_code okx_cust_site_uses_v.postal_code%TYPE,
664: state okx_cust_site_uses_v.state%TYPE,
665: province okx_cust_site_uses_v.province%TYPE,
666: county okx_cust_site_uses_v.county%TYPE,
667: country okx_cust_site_uses_v.country%TYPE);
668:
669:
670: TYPE l_k_bto_sto_data_tab_typ IS TABLE OF bto_sto_rec_typ INDEX BY BINARY_INTEGER;

Line 667: country okx_cust_site_uses_v.country%TYPE);

663: postal_code okx_cust_site_uses_v.postal_code%TYPE,
664: state okx_cust_site_uses_v.state%TYPE,
665: province okx_cust_site_uses_v.province%TYPE,
666: county okx_cust_site_uses_v.county%TYPE,
667: country okx_cust_site_uses_v.country%TYPE);
668:
669:
670: TYPE l_k_bto_sto_data_tab_typ IS TABLE OF bto_sto_rec_typ INDEX BY BINARY_INTEGER;
671:

Line 708: l_st_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder

704:
705: --
706: l_cust c_cust%ROWTYPE;
707: l_customer c_cust%ROWTYPE;
708: l_st_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder
709: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
710: l_st_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
711: l_st_address1 okx_cust_site_uses_v.address1%TYPE; -- address
712: l_st_address2 okx_cust_site_uses_v.address2%TYPE; -- address

Line 709: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder

705: --
706: l_cust c_cust%ROWTYPE;
707: l_customer c_cust%ROWTYPE;
708: l_st_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder
709: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
710: l_st_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
711: l_st_address1 okx_cust_site_uses_v.address1%TYPE; -- address
712: l_st_address2 okx_cust_site_uses_v.address2%TYPE; -- address
713: l_st_address3 okx_cust_site_uses_v.address3%TYPE; -- address

Line 710: l_st_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder

706: l_cust c_cust%ROWTYPE;
707: l_customer c_cust%ROWTYPE;
708: l_st_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder
709: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
710: l_st_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
711: l_st_address1 okx_cust_site_uses_v.address1%TYPE; -- address
712: l_st_address2 okx_cust_site_uses_v.address2%TYPE; -- address
713: l_st_address3 okx_cust_site_uses_v.address3%TYPE; -- address
714: l_st_address4 okx_cust_site_uses_v.address4%TYPE; -- address

Line 711: l_st_address1 okx_cust_site_uses_v.address1%TYPE; -- address

707: l_customer c_cust%ROWTYPE;
708: l_st_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder
709: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
710: l_st_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
711: l_st_address1 okx_cust_site_uses_v.address1%TYPE; -- address
712: l_st_address2 okx_cust_site_uses_v.address2%TYPE; -- address
713: l_st_address3 okx_cust_site_uses_v.address3%TYPE; -- address
714: l_st_address4 okx_cust_site_uses_v.address4%TYPE; -- address
715: l_st_city okx_cust_site_uses_v.city%TYPE; -- city

Line 712: l_st_address2 okx_cust_site_uses_v.address2%TYPE; -- address

708: l_st_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder
709: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
710: l_st_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
711: l_st_address1 okx_cust_site_uses_v.address1%TYPE; -- address
712: l_st_address2 okx_cust_site_uses_v.address2%TYPE; -- address
713: l_st_address3 okx_cust_site_uses_v.address3%TYPE; -- address
714: l_st_address4 okx_cust_site_uses_v.address4%TYPE; -- address
715: l_st_city okx_cust_site_uses_v.city%TYPE; -- city
716: l_st_postal_code okx_cust_site_uses_v.postal_code%TYPE; -- postal_code

Line 713: l_st_address3 okx_cust_site_uses_v.address3%TYPE; -- address

709: l_st_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
710: l_st_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
711: l_st_address1 okx_cust_site_uses_v.address1%TYPE; -- address
712: l_st_address2 okx_cust_site_uses_v.address2%TYPE; -- address
713: l_st_address3 okx_cust_site_uses_v.address3%TYPE; -- address
714: l_st_address4 okx_cust_site_uses_v.address4%TYPE; -- address
715: l_st_city okx_cust_site_uses_v.city%TYPE; -- city
716: l_st_postal_code okx_cust_site_uses_v.postal_code%TYPE; -- postal_code
717: l_st_state okx_cust_site_uses_v.state%TYPE; -- state

Line 714: l_st_address4 okx_cust_site_uses_v.address4%TYPE; -- address

710: l_st_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
711: l_st_address1 okx_cust_site_uses_v.address1%TYPE; -- address
712: l_st_address2 okx_cust_site_uses_v.address2%TYPE; -- address
713: l_st_address3 okx_cust_site_uses_v.address3%TYPE; -- address
714: l_st_address4 okx_cust_site_uses_v.address4%TYPE; -- address
715: l_st_city okx_cust_site_uses_v.city%TYPE; -- city
716: l_st_postal_code okx_cust_site_uses_v.postal_code%TYPE; -- postal_code
717: l_st_state okx_cust_site_uses_v.state%TYPE; -- state
718: l_st_province okx_cust_site_uses_v.province%TYPE; -- province

Line 715: l_st_city okx_cust_site_uses_v.city%TYPE; -- city

711: l_st_address1 okx_cust_site_uses_v.address1%TYPE; -- address
712: l_st_address2 okx_cust_site_uses_v.address2%TYPE; -- address
713: l_st_address3 okx_cust_site_uses_v.address3%TYPE; -- address
714: l_st_address4 okx_cust_site_uses_v.address4%TYPE; -- address
715: l_st_city okx_cust_site_uses_v.city%TYPE; -- city
716: l_st_postal_code okx_cust_site_uses_v.postal_code%TYPE; -- postal_code
717: l_st_state okx_cust_site_uses_v.state%TYPE; -- state
718: l_st_province okx_cust_site_uses_v.province%TYPE; -- province
719: l_st_county okx_cust_site_uses_v.county%TYPE; -- county

Line 716: l_st_postal_code okx_cust_site_uses_v.postal_code%TYPE; -- postal_code

712: l_st_address2 okx_cust_site_uses_v.address2%TYPE; -- address
713: l_st_address3 okx_cust_site_uses_v.address3%TYPE; -- address
714: l_st_address4 okx_cust_site_uses_v.address4%TYPE; -- address
715: l_st_city okx_cust_site_uses_v.city%TYPE; -- city
716: l_st_postal_code okx_cust_site_uses_v.postal_code%TYPE; -- postal_code
717: l_st_state okx_cust_site_uses_v.state%TYPE; -- state
718: l_st_province okx_cust_site_uses_v.province%TYPE; -- province
719: l_st_county okx_cust_site_uses_v.county%TYPE; -- county
720: l_st_country okx_cust_site_uses_v.country%TYPE; -- country

Line 717: l_st_state okx_cust_site_uses_v.state%TYPE; -- state

713: l_st_address3 okx_cust_site_uses_v.address3%TYPE; -- address
714: l_st_address4 okx_cust_site_uses_v.address4%TYPE; -- address
715: l_st_city okx_cust_site_uses_v.city%TYPE; -- city
716: l_st_postal_code okx_cust_site_uses_v.postal_code%TYPE; -- postal_code
717: l_st_state okx_cust_site_uses_v.state%TYPE; -- state
718: l_st_province okx_cust_site_uses_v.province%TYPE; -- province
719: l_st_county okx_cust_site_uses_v.county%TYPE; -- county
720: l_st_country okx_cust_site_uses_v.country%TYPE; -- country
721: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder

Line 718: l_st_province okx_cust_site_uses_v.province%TYPE; -- province

714: l_st_address4 okx_cust_site_uses_v.address4%TYPE; -- address
715: l_st_city okx_cust_site_uses_v.city%TYPE; -- city
716: l_st_postal_code okx_cust_site_uses_v.postal_code%TYPE; -- postal_code
717: l_st_state okx_cust_site_uses_v.state%TYPE; -- state
718: l_st_province okx_cust_site_uses_v.province%TYPE; -- province
719: l_st_county okx_cust_site_uses_v.county%TYPE; -- county
720: l_st_country okx_cust_site_uses_v.country%TYPE; -- country
721: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder
722: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder

Line 719: l_st_county okx_cust_site_uses_v.county%TYPE; -- county

715: l_st_city okx_cust_site_uses_v.city%TYPE; -- city
716: l_st_postal_code okx_cust_site_uses_v.postal_code%TYPE; -- postal_code
717: l_st_state okx_cust_site_uses_v.state%TYPE; -- state
718: l_st_province okx_cust_site_uses_v.province%TYPE; -- province
719: l_st_county okx_cust_site_uses_v.county%TYPE; -- county
720: l_st_country okx_cust_site_uses_v.country%TYPE; -- country
721: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder
722: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
723: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder

Line 720: l_st_country okx_cust_site_uses_v.country%TYPE; -- country

716: l_st_postal_code okx_cust_site_uses_v.postal_code%TYPE; -- postal_code
717: l_st_state okx_cust_site_uses_v.state%TYPE; -- state
718: l_st_province okx_cust_site_uses_v.province%TYPE; -- province
719: l_st_county okx_cust_site_uses_v.county%TYPE; -- county
720: l_st_country okx_cust_site_uses_v.country%TYPE; -- country
721: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder
722: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
723: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
724: l_exchange_type okc_conversion_attribs_v.conversion_type%TYPE;

Line 721: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder

717: l_st_state okx_cust_site_uses_v.state%TYPE; -- state
718: l_st_province okx_cust_site_uses_v.province%TYPE; -- province
719: l_st_county okx_cust_site_uses_v.county%TYPE; -- county
720: l_st_country okx_cust_site_uses_v.country%TYPE; -- country
721: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder
722: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
723: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
724: l_exchange_type okc_conversion_attribs_v.conversion_type%TYPE;
725: l_exchange_rate okc_conversion_attribs_v.conversion_rate%TYPE;

Line 722: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder

718: l_st_province okx_cust_site_uses_v.province%TYPE; -- province
719: l_st_county okx_cust_site_uses_v.county%TYPE; -- county
720: l_st_country okx_cust_site_uses_v.country%TYPE; -- country
721: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder
722: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
723: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
724: l_exchange_type okc_conversion_attribs_v.conversion_type%TYPE;
725: l_exchange_rate okc_conversion_attribs_v.conversion_rate%TYPE;
726: l_exchange_date okc_conversion_attribs_v.conversion_date%TYPE;

Line 723: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder

719: l_st_county okx_cust_site_uses_v.county%TYPE; -- county
720: l_st_country okx_cust_site_uses_v.country%TYPE; -- country
721: l_bt_cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE; -- cust acct id holder
722: l_bt_party_site_id okx_cust_site_uses_v.party_site_id%TYPE; -- bill to site id holder
723: l_bt_party_id okx_cust_site_uses_v.party_id%TYPE; -- bill to party id holder
724: l_exchange_type okc_conversion_attribs_v.conversion_type%TYPE;
725: l_exchange_rate okc_conversion_attribs_v.conversion_rate%TYPE;
726: l_exchange_date okc_conversion_attribs_v.conversion_date%TYPE;
727:

Line 816: FROM okx_cust_site_uses_v

812: ,province
813: ,postal_code
814: ,county
815: ,country
816: FROM okx_cust_site_uses_v
817: WHERE id1 = b_id1
818: AND id2 = b_id2;
819:
820: --