APPS.PO_SUBINVENTORIES_S3 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

    SELECT msub.asset_inventory,
           msi.inventory_asset_flag
    FROM   mtl_secondary_inventories msub,
	   mtl_system_items  	     msi
    WHERE  msub.secondary_inventory_name = x_subinventory
    AND	   msub.organization_id          = x_org_id
    AND	   msi.inventory_item_id	 = x_item_id
    AND	   msi.organization_id		 = x_org_id;

Line: 39

    SELECT intransit_type,
           fob_point
    FROM   mtl_interorg_parameters
    WHERE  from_organization_id = x_src_org_id
    AND	   to_organization_id   = x_dest_org_id;