APPS.OE_INVOICE_PUB dependencies on HZ_CUST_SITE_USES

Line 1354: FROM hz_cust_site_uses

1350: END IF;
1351: IF p_line_rec.ship_to_org_id IS NOT NULL THEN
1352: SELECT invoice_quantity_rule
1353: INTO l_overship_invoice_basis
1354: FROM hz_cust_site_uses
1355: WHERE site_use_id = p_line_rec.ship_to_org_id
1356: AND site_use_code = 'SHIP_TO';
1357: IF l_debug_level > 0 THEN
1358: oe_debug_pub.add( 'OVERSHIP_INVOICE_BASIS ( 2 ) : '||L_OVERSHIP_INVOICE_BASIS , 5 ) ;

Line 6379: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site

6375:
6376: SELECT acct_site.cust_account_id, site.cust_acct_site_id
6377: INTO p_x_interface_line_rec.ORIG_SYSTEM_BILL_CUSTOMER_ID
6378: ,p_x_interface_line_rec.ORIG_SYSTEM_BILL_ADDRESS_ID
6379: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site
6380: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
6381: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
6382: AND SITE.SITE_USE_ID = p_line_rec.invoice_to_org_id;
6383:

Line 6410: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site

6406:
6407: SELECT acct_site.cust_account_id, site.cust_acct_site_id
6408: INTO p_x_interface_line_rec.ORIG_SYSTEM_SHIP_CUSTOMER_ID
6409: ,l_orig_sys_ship_addr_id
6410: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site
6411: WHERE SITE.SITE_USE_CODE = 'SHIP_TO'
6412: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
6413: AND SITE.SITE_USE_ID = p_line_rec.ship_to_org_id;
6414:

Line 6792: FROM hz_cust_site_uses sub

6788: AND nvl(end_date_active, sysdate);
6789: ELSIF (l_territory_code = 'BILL' AND p_line_rec.invoice_to_org_id IS NOT NULL) THEN
6790: SELECT nvl(sub.territory_id,0)
6791: INTO p_x_interface_line_rec.territory_id
6792: FROM hz_cust_site_uses sub
6793: WHERE sub.site_use_id = p_line_rec.invoice_to_org_id;
6794: ELSIF (l_territory_code = 'SHIP' AND p_line_rec.ship_to_org_id IS NOT NULL) THEN
6795: SELECT nvl(sus.territory_id,0)
6796: INTO p_x_interface_line_rec.territory_id

Line 6797: FROM hz_cust_site_uses sus

6793: WHERE sub.site_use_id = p_line_rec.invoice_to_org_id;
6794: ELSIF (l_territory_code = 'SHIP' AND p_line_rec.ship_to_org_id IS NOT NULL) THEN
6795: SELECT nvl(sus.territory_id,0)
6796: INTO p_x_interface_line_rec.territory_id
6797: FROM hz_cust_site_uses sus
6798: WHERE sus.site_use_id = p_line_rec.ship_to_org_id;
6799: END IF;
6800: IF l_debug_level > 0 THEN
6801: oe_debug_pub.add( 'territory_id:'|| p_x_interface_line_rec.territory_id , 5 ) ;

Line 6947: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site

6943: WHERE organization_id = p_header_rec.invoice_to_org_id;*/
6944:
6945: SELECT acct_site.cust_account_id
6946: INTO l_hdr_inv_to_cust_id
6947: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site
6948: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
6949: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
6950: AND SITE.SITE_USE_ID = p_header_rec.invoice_to_org_id;
6951: