ORG_ID Versus ORGANIZATION_ID
I'm creating a SQL extract from EBS for inventory records. I note for PO records that org_id is used to denote the corporate family of the order. It appears that for inventory records, organization_id is used. While I don't think these are the same, it's not clear how they are different. How are they different? Are there any inventory-related tables that have both org_id and organization_id in the same table?
Also, is there a column in inventory tables that can be used to indicate active or inactive records by date?
With appreciation.