APPS.MSC_CL_MISCELLANEOUS dependencies on MSC_TP_SITE_ID_LID

Line 206: ||' MSC_TP_SITE_ID_LID tps '

202: ||' SELECT x.receipt_id,:v_instance_id,item.inventory_item_id,x.organization_id, TP.TP_ID,nvl(TPS.TP_SITE_ID,-1), '
203: ||' x.transaction_date, x.transaction_qty ,:v_current_date, :v_current_user, '
204: ||' :v_current_date, :v_current_user'
205: ||' FROM MRP_AP_PO_SUPPLIER_TRXS_V'||v_dblink||' x, MSC_TP_ID_LID tp, MSC_ITEM_ID_LID item, '
206: ||' MSC_TP_SITE_ID_LID tps '
207: ||' where x.inventory_item_id is not null and '
208: ||' x.inventory_item_id = item.sr_inventory_item_id and '
209: ||' item.sr_instance_id= :v_instance_id and '
210: ||' x.supplier_id = tp.sr_tp_id and '

Line 288: MSC_TP_SITE_ID_LID tsil

284: FROM msc_assignment_sets msa,
285: MSC_BOD_SOURCING_RULES_V sr_view,
286: MSC_ITEM_ID_LID iil,
287: MSC_TP_ID_LID til,
288: MSC_TP_SITE_ID_LID tsil
289: WHERE iil.inventory_item_id= sr_view.inventory_item_id
290: AND iil.sr_instance_id= sr_view.sr_instance_id
291: AND til.tp_id(+)= sr_view.supplier_id
292: AND til.sr_instance_id(+)= sr_view.sr_instance_id