APPS.ASO_CHECK_TCA_PVT dependencies on HZ_CUST_SITE_USES

Line 426: select cust_acct_site_id from hz_cust_site_uses

422: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
423: IS
424:
425: CURSOR get_cust_acct_site_id(l_site_use_id number) IS
426: select cust_acct_site_id from hz_cust_site_uses
427: where site_use_id = l_site_use_id;
428:
429: CURSOR C_Site_Use(l_sold_to_party_site NUMBER) IS
430: SELECT party_site_use_id

Line 1005: select cust_acct_site_id from hz_cust_site_uses

1001: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;
1002: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
1003:
1004: CURSOR get_cust_acct_site_id(l_site_use_id number) IS
1005: select cust_acct_site_id from hz_cust_site_uses
1006: where site_use_id = l_site_use_id;
1007:
1008: CURSOR C_Get_Sold_To_Info(qte_hdr NUMBER) IS
1009: SELECT cust_account_id, cust_party_id

Line 1968: hz_cust_site_uses

1964:
1965: CURSOR active_site_use_cur(l_acct_site_id NUMBER, l_site_type VARCHAR2) IS
1966: select site_use_id, status
1967: from
1968: hz_cust_site_uses
1969: where
1970: cust_acct_site_id = l_acct_site_id
1971: and site_use_code = l_site_type
1972: and status = 'A';

Line 1977: hz_cust_site_uses

1973:
1974: CURSOR inactive_site_use_cur(l_acct_site_id NUMBER, l_site_type VARCHAR2) IS
1975: select site_use_id, status
1976: from
1977: hz_cust_site_uses
1978: where
1979: cust_acct_site_id = l_acct_site_id
1980: and site_use_code = l_site_type
1981: and status <> 'A';

Line 1988: hz_cust_site_uses a, hz_cust_acct_sites b

1984: /*
1985: CURSOR site_use_cur(cust_acct NUMBER, party_site NUMBER, site_type VARCHAR2) IS
1986: select a.site_use_id, b.status,a.status
1987: from
1988: hz_cust_site_uses a, hz_cust_acct_sites b
1989: where
1990: b.cust_account_id = cust_acct
1991: and b.party_site_id = party_site
1992: and a.cust_acct_site_id = b.cust_acct_site_id