APPS.PO_INV_THIRD_PARTY_STOCK_MDTR SQL Statements

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

Line: 69

    SELECT /*+FIRST_ROWS */ 1
    FROM   mtl_consumption_transactions mct,
           mtl_material_transactions mmt
    WHERE  mmt.transaction_id = mct.transaction_id
           AND mmt.transaction_source_id = p_transaction_source_id
           AND mmt.inventory_item_id = p_item_id
           AND Nvl(mct.consumption_processed_flag,'N') <> 'Y';

Line: 78

    SELECT /*+FIRST_ROWS */ 1
    FROM   mtl_consumption_transactions mct,
           mtl_material_transactions mmt
    WHERE  mmt.transaction_id = mct.transaction_id
           AND mmt.transaction_source_id = p_transaction_source_id
           AND Nvl(mct.consumption_processed_flag,'N') <> 'Y';

Line: 103

      SELECT count('Y')
    INTO   l_count_cons_trans
    FROM   dual
    WHERE  EXISTS(SELECT 'Y'
                  FROM   MTL_CONSUMPTION_TRANSACTIONS MCT,
                         MTL_MATERIAL_TRANSACTIONS    MMT
                  WHERE  MMT.TRANSACTION_ID = MCT.TRANSACTION_ID
                  AND    MMT.TRANSACTION_SOURCE_ID = p_transaction_source_id
                  AND    MMT.INVENTORY_ITEM_ID = p_item_id
		  AND    nvl(MCT.CONSUMPTION_PROCESSED_FLAG, 'N') <> 'Y');

Line: 114

    SELECT count('Y')
    INTO   l_count_cons_trans
    FROM   dual
    WHERE  EXISTS(SELECT 'Y'
                  FROM   MTL_CONSUMPTION_TRANSACTIONS MCT,
                         MTL_MATERIAL_TRANSACTIONS    MMT
                  WHERE  MMT.TRANSACTION_ID = MCT.TRANSACTION_ID
                  AND    MMT.TRANSACTION_SOURCE_ID = p_transaction_source_id
		  AND    nvl(MCT.CONSUMPTION_PROCESSED_FLAG, 'N') <> 'Y');

Line: 174

    FOR po_asl IN (SELECT item_id, vendor_site_id
                     FROM po_asl_attributes
                    WHERE vendor_id = p_vendor_id
                      AND vendor_site_id IS NOT NULL
                      AND consigned_from_supplier_flag IS NOT NULL
                 ORDER BY consigned_from_supplier_flag DESC)
    LOOP
      SELECT SUM(primary_transaction_quantity)
        INTO l_onhand_qty
        FROM mtl_onhand_quantities_detail
       WHERE inventory_item_id = po_asl.item_id
         AND owning_organization_id = po_asl.vendor_site_id
         AND owning_tp_type = 1;

Line: 239

    SELECT item_id BULK COLLECT INTO item_id_tbl
      FROM po_asl_attributes
     WHERE vendor_site_id = p_vendor_site_id
       AND consigned_from_supplier_flag IS NOT NULL
     ORDER BY consigned_from_supplier_flag DESC;

Line: 247

      SELECT SUM(primary_transaction_quantity)
        INTO l_onhand_qty
        FROM mtl_onhand_quantities_detail
       WHERE inventory_item_id = item_id_tbl(i)
         AND ((owning_organization_id = p_vendor_site_id
         AND   owning_tp_type = 1)
          OR  (planning_organization_id = p_vendor_site_id
         AND   planning_tp_type = 1));