DBA Data[Home] [Help]

APPS.OE_ORDER_CACHE dependencies on OE_SOLD_TO_ORGS_V

Line 722: --The Sold_To_Org_Cache was selecting oe_sold_to_orgs_v.organization_id into g_sold_to_rec.org_id.

718: if l_debug_level > 0 then
719: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SOLD_TO_ORG', 1);
720: end if;
721: --MOAC Changes
722: --The Sold_To_Org_Cache was selecting oe_sold_to_orgs_v.organization_id into g_sold_to_rec.org_id.
723: --To have a code consistency added a new column "sold_to_org_id" in "Sold_To_Org_Rec_Type".
724: --Now oe_sold_to_orgs_v.organization_id is selected into g_sold_to_rec.sold_to_org_id and
725: --the OU in g_sold_to_rec.org_id
726:

Line 724: --Now oe_sold_to_orgs_v.organization_id is selected into g_sold_to_rec.sold_to_org_id and

720: end if;
721: --MOAC Changes
722: --The Sold_To_Org_Cache was selecting oe_sold_to_orgs_v.organization_id into g_sold_to_rec.org_id.
723: --To have a code consistency added a new column "sold_to_org_id" in "Sold_To_Org_Rec_Type".
724: --Now oe_sold_to_orgs_v.organization_id is selected into g_sold_to_rec.sold_to_org_id and
725: --the OU in g_sold_to_rec.org_id
726:
727: l_current_org_id := MO_Global.Get_Current_Org_Id() ;
728:

Line 749: FROM OE_SOLD_TO_ORGS_V

745: , g_sold_to_rec.freight_terms_code
746: , g_sold_to_rec.ship_partial_allowed
747: , g_sold_to_rec.shipping_method_code
748: , g_sold_to_rec.order_type_id
749: FROM OE_SOLD_TO_ORGS_V
750: WHERE ORGANIZATION_ID = p_key;
751:
752: g_sold_to_rec.org_id := l_current_org_id ; -- MOAC Changes
753: