APPS.MSD_COMMON_UTILITIES_LB dependencies on MSC_TRADING_PARTNERS

Line 104: MSC_TRADING_PARTNERS mtp

100: CURSOR c_category_name
101: IS
102: select mic.category_name
103: from msc_item_categories mic ,
104: MSC_TRADING_PARTNERS mtp
105: where
106: mtp.partner_type = 3
107: and mtp.sr_tp_id = mtp.master_organization
108: and mtp.sr_tp_id = mic.organization_id

Line 140: MSC_TRADING_PARTNERS mtp

136: CURSOR c_category_desc
137: IS
138: select mic.description
139: from msc_item_categories mic ,
140: MSC_TRADING_PARTNERS mtp
141: where
142: mtp.partner_type = 3
143: and mtp.sr_tp_id = mtp.master_organization
144: and mtp.sr_tp_id = mic.organization_id

Line 505: msc_trading_partners

501: IS
502: CURSOR c_calendar
503: IS
504: select calendar_code from
505: msc_trading_partners
506: where partner_type = 3
507: and sr_instance_id = p_instance_id
508: and sr_tp_id = p_org_id ;
509:

Line 766: msc_trading_partners mtp

762: cursor c1 is
763: select msi2.uom_code
764: from msc_system_items msi,
765: msc_system_items msi2,
766: msc_trading_partners mtp
767: where msi2.organization_id = mtp.master_organization
768: and msi.organization_id = mtp.sr_tp_id
769: and msi.sr_instance_id = mtp.sr_instance_id
770: and msi.inventory_item_id = msi2.inventory_item_id