APPS.CST_PENDINGTXNSREPORT_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 1457: l_min_txn_if_id MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID%TYPE;

1453: l_ctx NUMBER;
1454: l_xml_temp CLOB;
1455: l_offset PLS_INTEGER;
1456: l_stmt_num NUMBER;
1457: l_min_txn_if_id MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID%TYPE;
1458: l_max_txn_if_id MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID%TYPE;
1459: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1460: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.' || l_full_name;
1461:

Line 1458: l_max_txn_if_id MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID%TYPE;

1454: l_xml_temp CLOB;
1455: l_offset PLS_INTEGER;
1456: l_stmt_num NUMBER;
1457: l_min_txn_if_id MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID%TYPE;
1458: l_max_txn_if_id MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID%TYPE;
1459: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1460: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.' || l_full_name;
1461:
1462: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);

Line 1494: FROM mtl_transactions_interface

1490: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
1491:
1492: SELECT min (TRANSACTION_INTERFACE_ID)
1493: INTO l_min_txn_if_id
1494: FROM mtl_transactions_interface
1495: WHERE organization_id = i_org_id
1496: AND transaction_date <= i_period_end_date
1497: AND process_flag <> 9;
1498:

Line 1501: FROM mtl_transactions_interface

1497: AND process_flag <> 9;
1498:
1499: SELECT max (TRANSACTION_INTERFACE_ID)
1500: INTO l_max_txn_if_id
1501: FROM mtl_transactions_interface
1502: WHERE organization_id = i_org_id
1503: AND transaction_date <= i_period_end_date
1504: AND process_flag <> 9;
1505:

Line 1547: FROM mtl_transactions_interface mti,

1543: ml1.meaning LOCK_FLAG_DESC,
1544: mti.LOCK_FLAG,
1545: mti.ERROR_CODE,
1546: mti.ERROR_EXPLANATION
1547: FROM mtl_transactions_interface mti,
1548: mtl_item_flexfields mif,
1549: mtl_serial_numbers_interface msni,
1550: mtl_transaction_lots_interface mtli,
1551: mtl_parameters mp,