DBA Data[Home] [Help]

APPS.MSC_CALENDAR dependencies on MSC_ITEM_SUPPLIERS

Line 1096: FROM MSC_ITEM_SUPPLIERS

1092: INTO l_calendar_code, p_association_type
1093: FROM (SELECT delivery_calendar_code, decode(supplier_site_id,
1094: null, C_ITEM_VENDOR,
1095: C_ITEM_VENDOR_SITE) association_type
1096: FROM MSC_ITEM_SUPPLIERS
1097: WHERE SR_INSTANCE_ID = p_instance_id
1098: AND PLAN_ID = p_plan_id
1099: AND INVENTORY_ITEM_ID = p_inventory_item_id
1100: AND SUPPLIER_ID = p_partner_id

Line 1272: FROM MSC_ITEM_SUPPLIERS

1268: INTO l_calendar_code, p_association_type
1269: FROM (SELECT delivery_calendar_code, decode(supplier_site_id,
1270: null, C_ITEM_VENDOR,
1271: C_ITEM_VENDOR_SITE) association_type
1272: FROM MSC_ITEM_SUPPLIERS
1273: WHERE SR_INSTANCE_ID = p_instance_id
1274: AND PLAN_ID = p_plan_id
1275: AND INVENTORY_ITEM_ID = p_inventory_item_id
1276: AND SUPPLIER_ID = p_partner_id