DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on HZ_CUST_SITE_USES_ALL

Line 2278: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is

2274: l_rule_type VARCHAR2(10);
2275: l_line_rec_for_hold OE_Order_PUB.Line_Rec_Type; --ER#7479609
2276: l_header_rec_for_hold OE_Order_PUB.Header_Rec_Type; --ER#7479609
2277:
2278: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
2279: SELECT cust_acct.cust_account_id,
2280: cust_Acct.party_id,
2281: acct_site.party_site_id,
2282: site_use.org_id

Line 2284: HZ_CUST_SITE_USES_ALL site_use,

2280: cust_Acct.party_id,
2281: acct_site.party_site_id,
2282: site_use.org_id
2283: FROM
2284: HZ_CUST_SITE_USES_ALL site_use,
2285: HZ_CUST_ACCT_SITES_ALL acct_site,
2286: HZ_CUST_ACCOUNTS_ALL cust_Acct
2287: WHERE site_use.site_use_id = p_site_org_id
2288: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id