APPS.OE_INVOICE_PUB dependencies on HZ_CUST_SITE_USES

Line 1571: FROM hz_cust_site_uses

1567: END IF;
1568: IF p_line_rec.ship_to_org_id IS NOT NULL THEN
1569: SELECT invoice_quantity_rule
1570: INTO l_overship_invoice_basis
1571: FROM hz_cust_site_uses
1572: WHERE site_use_id = p_line_rec.ship_to_org_id
1573: AND site_use_code = 'SHIP_TO';
1574: IF l_debug_level > 0 THEN
1575: oe_debug_pub.add( 'OVERSHIP_INVOICE_BASIS ( 2 ) : '||L_OVERSHIP_INVOICE_BASIS , 5 ) ;

Line 6652: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site

6648:
6649: SELECT acct_site.cust_account_id, site.cust_acct_site_id
6650: INTO p_x_interface_line_rec.ORIG_SYSTEM_BILL_CUSTOMER_ID
6651: ,p_x_interface_line_rec.ORIG_SYSTEM_BILL_ADDRESS_ID
6652: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site
6653: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
6654: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
6655: AND SITE.SITE_USE_ID = p_line_rec.invoice_to_org_id;
6656:

Line 6683: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site

6679:
6680: SELECT acct_site.cust_account_id, site.cust_acct_site_id
6681: INTO p_x_interface_line_rec.ORIG_SYSTEM_SHIP_CUSTOMER_ID
6682: ,l_orig_sys_ship_addr_id
6683: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site
6684: WHERE SITE.SITE_USE_CODE = 'SHIP_TO'
6685: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
6686: AND SITE.SITE_USE_ID = p_line_rec.ship_to_org_id;
6687:

Line 7077: FROM hz_cust_site_uses sub

7073: AND nvl(end_date_active, sysdate);
7074: ELSIF (l_territory_code = 'BILL' AND p_line_rec.invoice_to_org_id IS NOT NULL) THEN
7075: SELECT nvl(sub.territory_id,0)
7076: INTO p_x_interface_line_rec.territory_id
7077: FROM hz_cust_site_uses sub
7078: WHERE sub.site_use_id = p_line_rec.invoice_to_org_id;
7079: ELSIF (l_territory_code = 'SHIP' AND p_line_rec.ship_to_org_id IS NOT NULL) THEN
7080: SELECT nvl(sus.territory_id,0)
7081: INTO p_x_interface_line_rec.territory_id

Line 7082: FROM hz_cust_site_uses sus

7078: WHERE sub.site_use_id = p_line_rec.invoice_to_org_id;
7079: ELSIF (l_territory_code = 'SHIP' AND p_line_rec.ship_to_org_id IS NOT NULL) THEN
7080: SELECT nvl(sus.territory_id,0)
7081: INTO p_x_interface_line_rec.territory_id
7082: FROM hz_cust_site_uses sus
7083: WHERE sus.site_use_id = p_line_rec.ship_to_org_id;
7084: END IF;
7085: IF l_debug_level > 0 THEN
7086: oe_debug_pub.add( 'territory_id:'|| p_x_interface_line_rec.territory_id , 5 ) ;

Line 7232: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site

7228: WHERE organization_id = p_header_rec.invoice_to_org_id;*/
7229:
7230: SELECT acct_site.cust_account_id
7231: INTO l_hdr_inv_to_cust_id
7232: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site
7233: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
7234: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
7235: AND SITE.SITE_USE_ID = p_header_rec.invoice_to_org_id;
7236: