APPS.INV_3PL_SEEDED_SOURCES dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 541: and organization_id in (select organization_id from org_organization_definitions

537: transaction_quantity , current_onhand, Trunc(last_receipt_date) last_rcpt_date,
538: number_of_days, Trunc(last_invoiced_date) last_inv_date
539: from mtl_3pl_locator_occupancy inv
540: WHERE client_code = p_client_code
541: and organization_id in (select organization_id from org_organization_definitions
542: where operating_unit = p_operating_unit_id)
543: and (( nvl(last_invoiced_date, p_source_to_date) <= p_source_to_date )
544: AND ( transaction_date <= p_source_to_date ) )
545: order by organization_id, locator_id;

Line 684: and organization_id in (select organization_id from org_organization_definitions

680: transaction_quantity , current_onhand, Trunc(last_receipt_date) last_rcpt_date,
681: number_of_days, Trunc(last_invoiced_date) last_inv_date
682: from mtl_3pl_locator_occupancy inv
683: WHERE client_code = p_client_code
684: and organization_id in (select organization_id from org_organization_definitions
685: where operating_unit = p_operating_unit_id)
686: and (( nvl(last_invoiced_date, p_source_to_date) <= p_source_to_date )
687: AND ( transaction_date <= p_source_to_date ) )
688: order by organization_id, locator_id;

Line 875: and organization_id in (select organization_id from org_organization_definitions

871: transaction_quantity , current_onhand, Trunc(last_receipt_date) last_rcpt_date,
872: number_of_days, Trunc(last_invoiced_date) last_inv_date
873: from mtl_3pl_locator_occupancy inv
874: WHERE client_code = p_client_code
875: and organization_id in (select organization_id from org_organization_definitions
876: where operating_unit = p_operating_unit_id)
877: and (( nvl(last_invoiced_date, p_source_to_date) <= p_source_to_date )
878: AND ( transaction_date <= p_source_to_date ) )
879: order by organization_id, locator_id;